Thread: helpp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default 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 ????