formula help

  • Thread starter Thread starter newbie
  • Start date Start date
N

newbie

Please help me in configuring formula for the following problem:

I want a formula for the extra amount I am paying, by way of commission and
tax for the transaction carried out by me

The extra amount I am paying is calculated as follows:

1. 0.75% of transaction value or $25 whichever is higher. (Commission),
2. 10.2% tax on commission,
3. 0.1% add tax on transaction value.

Thus for a transaction of $3400 I am paying as follows

1. 0.75% of 3400.00 : 25.50
2. 10.2% of 25.50 : 2.60
3. 0.1% of 3400.00 : 3.40
_______
Total : 31.50

Where as for a transaction of $3260 I am paying as follows

1. (0.75% of 3260 is $24.45 thus I am paying) : 25.00
2. 10.25% of 25.00 : 2.55
3. 0.1% of 3260 : 3.26

_______

Total :
30.81

I want a single formula where input of transaction value ( of $3400.00 or
$3260.00) will give me the extra amount I have to pay .

Regards.
 
Sorry for double posting.
Due to having same header mine was inside B.B's post and hence couldn't find
it.
hope you will understand my reason for double posting.
Karthik thanks for pointing out the mistake in 2nd example.
In both cases it will be 10.2%.
Thanks to all of you for the help extended.

newbie wrote:
|> Please help me in configuring formula for the following problem:
|>
|> I want a formula for the extra amount I am paying, by way of
|> commission and tax for the transaction carried out by me
|>
|> The extra amount I am paying is calculated as follows:
|>
|> 1. 0.75% of transaction value or $25 whichever is higher.
|> (Commission),
|> 2. 10.2% tax on commission,
|> 3. 0.1% add tax on transaction value.
|>
|> Thus for a transaction of $3400 I am paying as follows
|>
|> 1. 0.75% of 3400.00 : 25.50
|> 2. 10.2% of 25.50 : 2.60
|> 3. 0.1% of 3400.00 : 3.40
|> _______
|> Total : 31.50
|>
|> Where as for a transaction of $3260 I am paying as follows
|>
|> 1. (0.75% of 3260 is $24.45 thus I am paying) : 25.00
|> 2. 10.25% of 25.00 :
|> 2.55
|> 3. 0.1% of 3260 :
|> 3.26
|>
|> _______
|>
|> Total
|> :
|> 30.81
|>
|> I want a single formula where input of transaction value ( of
|> $3400.00 or $3260.00) will give me the extra amount I have to pay .
|>
|> Regards.
 
Back
Top