View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default nested if statementss.

H11 = 172 500 000

i have in A1 : =IF(h11<=0,0,IF(H11-6000000=0,6000000*2%," no tax"))


i have in A2 :
=IF(h11-6000000-9000000=0,9000000*5%,IF(h11-6000000=0,(H11-6000000)*5%,0))


i have in A3 :
=IF(H11-6000000-9000000-15000000=0,15000000*7%,IF(H11-6000000-9000000=0,(H11-6000000-9000000)*7%,0))


i have in A4 :
=IF(H11-6000000-9000000-15000000-30000000=0,30000000*11%,IF(H11-6000000-9000000-15000000=0,(H11-6000000-9000000-15000000)*11%,0))

i have in A5 :
=IF(H11-6000000-9000000-15000000-30000000-60000000=0,60000000*15%,IF(H11-6000000-9000000-15000000-30000000=0,(H11-6000000-9000000-15000000-30000000)*15%,0))

i have in A6 :
=IF(H11-6000000-9000000-15000000-30000000-60000000-120000000=0,1200000000,IF(H11-6000000-9000000-15000000-30000000-60000000=0,(H11-6000000-9000000-15000000-30000000-60000000)*20%,0))

now guys , what should i do in order to make them in ONE SINGLE FORMULA in
cell B1 ??

FOR THE ONE WHO SOLVE THIS ONE I TELL HIM PREVIOUSLY : " RESPECT "