formula help

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.
 
K

Karthik Bhat - Bangalore

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
 
K

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
 
R

René

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)
 
R

René

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)
 
Top