If Error Combined with IF Not Blank

Tony Katt

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

Hi @Tony Katt,

This should do the trick:

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

Any problems/questions then just post! 🙂

Tony Katt

https://community.smartsheet.com/discussion/comment/400717#Comment_400717

Excellent, Thanks!

Nick Korna

Hi @Tony Katt,

This should do the trick:

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

Any problems/questions then just post! 🙂

Tony Katt

https://community.smartsheet.com/discussion/comment/400717#Comment_400717

Excellent, Thanks!

Nick Korna

No problem, glad to help! 😊