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...
catherine9910 Thanks. That helps a lot as I would not have guessed your intentions otherwise. Please see attached. I believe it does what you need.
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