Formula

[Jonesdinah]

Can anyone help me with a formula I use in my payroll.

IF(F33<38.85,F33*10%,(F33*22%-4.66))+IF(F33>604,F33*40%-4.66)

I realise the add sign is wrong because it is adding the middle section (22%)
to the end section (40%) instead of an and/or choice.

Any ideas?

 

[Domenic]

Try the following...

=IF(F33<38.85,F33*10%,IF(F33<605,F33*22%-4.66,F33*40%-4.66))

Hope this helps!

 

[norika]

Jonesdinah

Try the following:

IF(F33<38.85,F33*10%,IF(38.85<F3<604,F33*22%-4.66,F33*40%-4.66))

HTH

norik