am handling a formula which is throwing correct amounts for the three clauses but not giving the correct result for the last clause..... i am unable to locate where it went wrong!!
=IIf([BASICPEN]<=3550,[BASICPEN]*0.24*[DRS]/100,IIf([BASICPEN]>3550<=5650,(3550*0.24*[DRS]/100)+(([BASICPEN]-3550)*0.2*[DRS]/100),IIf([BASICPEN]>5650<=6010,(3550*0.24*[DRS]/100)+(2100*0.2*[DRS]/100)+(([BASICPEN]-5650)*0.12*[DRS]/100),IIf([BASICPEN]>6010,(3550*0.24*[DRS]/100)+(2100*0.2*[DRS]/100)+(360*0.12*[DRS]/100)+(([BASICPEN]-6010)*0.06*[DRS]/100),0))))
when the BASICPEN is 10000/- and DRS is 32 it should give Rs.497.46
but its giving Rs.685.44 ......
...any clue!!!!
=IIf([BASICPEN]<=3550,[BASICPEN]*0.24*[DRS]/100,IIf([BASICPEN]>3550<=5650,(3550*0.24*[DRS]/100)+(([BASICPEN]-3550)*0.2*[DRS]/100),IIf([BASICPEN]>5650<=6010,(3550*0.24*[DRS]/100)+(2100*0.2*[DRS]/100)+(([BASICPEN]-5650)*0.12*[DRS]/100),IIf([BASICPEN]>6010,(3550*0.24*[DRS]/100)+(2100*0.2*[DRS]/100)+(360*0.12*[DRS]/100)+(([BASICPEN]-6010)*0.06*[DRS]/100),0))))
when the BASICPEN is 10000/- and DRS is 32 it should give Rs.497.46
but its giving Rs.685.44 ......
...any clue!!!!