If Error Combined with IF Not Blank

Tony Katt · 10/18/23

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.

Nick Korna · 10/19/23

This should do the trick:

=IFERROR(IF(NOT(ISBLANK(EV@row)), EV@row / PV@row), 0)

Any problems/questions then just post! 🙂

Tony Katt · 10/19/23

Excellent, Thanks!

Nick Korna · 10/19/23

This should do the trick:

=IFERROR(IF(NOT(ISBLANK(EV@row)), EV@row / PV@row), 0)

Any problems/questions then just post! 🙂

Tony Katt · 10/19/23

Excellent, Thanks!

Nick Korna · 10/19/23

No problem, glad to help! 😊

Best Answers