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 "
|