#INVALID OPERATION for multiplying with zero

Gia
Gia ✭✭
edited 10/04/23 in Formulas and Functions

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.


Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!