If Function

[Charlene Durand]

I am trying to do diffrent amounts for PAYE scales / percentages please help below is my formula


=IF($AB9<6392.31,0,($AB9-6392.31)*0.18),IF($AB9<15838.53,0,($AB9-15838.53)*0.26)

 

[Joe4]

The strucutre of how you are nesting the IF statements is incorrect.
See here for details and examples: IF function – nested formulas and avoiding pitfalls

If you need help figuring it out, please explain how it should work, in plain English (it can be difficult to figure out how exactly you want it to work from a faulty formula).

 

[Charlene Durand]

I have two diffrent PAYE thresholds, the one is if my Gross is from 6392.31 then my PAYE has to be worked out on the deduction of 18%. the other is when i earn more than 15838.54 then my PAYE has to be worked out on the 26% deduction

Hope this makes sence

 

[Joe4]

Try this:
=(MAX(AB9-6392.31,0)*0.18)+(MAX(AB9-15838.54,0)*0.08)