If Error Combined with IF Not Blank

Options

Smartsheet Community:

I am Trying to Add If Error to The Formula Below So The Result is 0 Instead of #DIVIDE BY ZERO

Current Formula: =IF(NOT(ISBLANK(EV@row)), EV@row / PV@row)

Thanks in Advance.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!