IF Statement

James Hyde

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!

Jeff Reisman

It looks like you have a space between "=IF" and the rest of the formula.

Jeff Reisman

It looks like you have a space between "=IF" and the rest of the formula.

James Hyde

🤣

THANK YOU!!!!