Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 " |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nested if | Excel Worksheet Functions | |||
nested if | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If help | Excel Worksheet Functions | |||
Nested If with And | Excel Worksheet Functions |