Forum Discussion
IF + XLOOKUP Formula
Hello, I am trying to put 2 formulas together. I have gotten the XLOOKUP formula to work perfectly, but not when I added the IF statement (only if the column says "HS"). =XLOOKUP(A3,'Automat...
Real quick, this formula returns the #DIV/0 error. How do I get it to return zero instead of that error?
=(H3+I3)/J3
=(H3+I3)/J3
