If formulas

hi ,im new to excel, i am trying to work out a formula to calculate payg withholding in excel, ihave got this far
=IF(D6>674,SUM(G6),"") but i need to add other conditions ie if less than x amont = another sum

You can use nested IF functions.

If D6>674 then G6
else if E6<13 then G7
else “”



or if you need multiple criteria to be true at the same time, you can use the AND() function.

If D6>674 and E6<13 then G6
else “”



The delimiter between items can be “;” or “,” depending on your locale (country specific settings).

Welcome to the forum! :slight_smile: