helpp
i have an amount of 265000000
and i would like to take into considerattion the following :
if this amount is between 0 and 6000000......then 6000000*2%
if this amount is above 6000000 and also reach to 9000000....then
6000000*2%+9000000*5%
if this amount is above 6000000 and 9000000 and also reach to
15000000...then 6000000*2%+9000000*5%+15000000*7%
if this amount is above 6000000 and 9000000 and 15000000 and also reach to
30000000...then 6000000*2%+9000000*5%+15000000*7%+30000000*11%
if this amount is above 6000000 and 9000000 and 15000000 and 30000000 and
also reach to 60000000....then
6000000*2%+9000000*5%+15000000*7%+30000000*11%+600 00000*15%
if this amount is above 60000000 and 9000000 and 15000000 and 30000000 and
60000000 and also reach to 120000000 OR ABOVE...then
6000000*2%+9000000*5%+15000000*7%+30000000*11%+600 00000*15% +the remaining
number *20%
what should i do in order to make them in a formula in a single cell ????
|