Augustinraj.a
New Member
Dear Team,
i have created the IF condition for the one cell(Income Tax Purpose) where am not able to close the brackets.
This is the formula  can you please help me this
=ROUND(IF(((TODAY()E3)/365)<60,IF(BB3<=250000,0,IF(BB3<=500000,((BB3250000)*5%),IF(BB3<=750000,((BB3500000)*10%+12500),IF(BB3<=1000000,((BB3750000)*20%+37500),IF(BB3<=1250000,((BB31000000)*25%+75000),IF(BB3<=1500000,((BB31250000)*30%+125000),((BB31500000)*30%+187500))))))),IF(((TODAY()E3)/365)>80,IF(BB3<=500000,0,IF(BB3<=750000,((BB3500000)*10%),IF(BB3<=1000000,((BB3750000)*15%+25000),IF(BB3<=1250000,((BB31000000)*20%+62500),IF(BB3<=1500000,((BB31250000)*25%+112500),((BB31500000)*30%)+175000)),IF(BB3<=300000,0,IF(BB3<=500000,((BB3300000)*5%),IF(BB3<=750000,((BB3500000)*10%+10000),IF(BB3<=1000000,((BB3750000)*15%+35000),IF(BB3<=1250000,((BB31000000)*20%+72500),IF(BB3<=1500000,((BB31250000)*25%+122500),((BB31500000)*30%+185000))))))),0)
Augustin 
9941678910
i have created the IF condition for the one cell(Income Tax Purpose) where am not able to close the brackets.
This is the formula  can you please help me this
=ROUND(IF(((TODAY()E3)/365)<60,IF(BB3<=250000,0,IF(BB3<=500000,((BB3250000)*5%),IF(BB3<=750000,((BB3500000)*10%+12500),IF(BB3<=1000000,((BB3750000)*20%+37500),IF(BB3<=1250000,((BB31000000)*25%+75000),IF(BB3<=1500000,((BB31250000)*30%+125000),((BB31500000)*30%+187500))))))),IF(((TODAY()E3)/365)>80,IF(BB3<=500000,0,IF(BB3<=750000,((BB3500000)*10%),IF(BB3<=1000000,((BB3750000)*15%+25000),IF(BB3<=1250000,((BB31000000)*20%+62500),IF(BB3<=1500000,((BB31250000)*25%+112500),((BB31500000)*30%)+175000)),IF(BB3<=300000,0,IF(BB3<=500000,((BB3300000)*5%),IF(BB3<=750000,((BB3500000)*10%+10000),IF(BB3<=1000000,((BB3750000)*15%+35000),IF(BB3<=1250000,((BB31000000)*20%+72500),IF(BB3<=1500000,((BB31250000)*25%+122500),((BB31500000)*30%+185000))))))),0)
Augustin 
9941678910
Attachments

19.4 KB Views: 5