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.
 
Hi newbie

If A1 contains transaction value then enter this formula in b1 to get
the total of charges:
=MAX(A1*0.75%,25)*1.1025+A1*0.001


Thanks
Karthik Bhat
BAngalore
 
Hi newbie

Lets say you enter the transaction value in cell A1 then the formula to
get the sum total of all commission and tax is

=MAX(A1*0.75%,25)*1.1025+A1*0.001.

You have used 10.2 in first and 10.25 in the second example. Please use
the correct one in the formula..

Thanks
Karthik Bhat
Bangalore
 
If the amount is in Cell A1, then the following formula should do the
trick:

=(MAX(0,0075*A1;25)*1,1025)+(0,001*A1)
 
If the amount is in cell A1, then the formula (in any other cell)
should be:
=(MAX(0,0075*A1;25)*1,1025)+(0,001*A1)
 
Back
Top