Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ???? |