IF Statement
Hello,
I"m trying to setup a formula that if the reference cell = 0, then it prints zero (instead of @INVALID OPERATION)
I can't seem to determine why I keep getting unparseable, not matter how I change it around.
=IF ([Brand Funded Scanners]@row = 0, "0", [Brand Funded Scanners]@row * 259)
Appreciate any assistance!
Best Answer
-
It looks like you have a space between "=IF" and the rest of the formula.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
It looks like you have a space between "=IF" and the rest of the formula.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
🤣
THANK YOU!!!!
Help Article Resources
Categories
Check out the Formula Handbook template!
