macosformulaiwork

Adjust formula for two cells that are 0 in iWork

I need help adding another rule to my formula, I need it to also say IF U17 and X17 both have 0 in them, then leave blank

Formula Y17

IF(OR(U17="",X17=""),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,T17)))

If two cells have 0, then leave blank and also if two cells are blank to leave blank

Thanks

Solution

  • you need to use the AND function.

    IF(OR(U17="",X17="",AND(U17=0,X17=0)),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,T17)))

    this will leave blank if either u17 or x17 is blank or both of them are 0

    if you want to leave blank only if both of them are blank or both of them are 0 then the function is

    IF(OR(AND(U17="",X17=""),AND(U17=0,X17=0)),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,T17)))

    you didn't specify in your request which one do you need.