PAYE Formula

[Charlene Durand]

Hi all i have the following formula but i dont want to calculate anything if the amount is less than R6512.51 as 18% Tax is due only above of that amount.


=SUM(Gross Pay-6512.51)*18%

 

[wideboydixon]

=IF(GrossPay<6512.51,0,(GrossPay-6512.51)*0.18)

No SUM required as far as I can see.

WBD

 

[njimack]

=min(0,6512.51)*18%

 

[Charlene Durand]

Thank you so much it worked