If formulas

vbimport

#1

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


#2

You can use nested IF functions.

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

becomes:

IF(D6>674;G6;IF(E6<13;G7;""))

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 “”

becomes

IF(AND(D6>674;E6<13);G6;"")

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

Welcome to the forum! :slight_smile: