#INVALID OPERATION for multiplying with zero
I am trying to multiply two cells and I get and error when one is a zero.
The "Number of Boxes to Order" column has an IF formula in it. The price column has a link from another sheet. I'm not sure why I'm getting an error when the IF formula spits out a zero value.
Help Article Resources
Check out the Formula Handbook template!