Forum Discussion

Copper Contributor

Sep 01, 2018

IFERROR formula

I am trying use IFERROR to return a 0 where there is a "division by 0 error", as per the formula: =IFERROR((N3-Q3)/N3,0) i.e. if N3 = 0. However, I keep getting a formula error message. Where am I ...

Formulas and Functions

Mark Norris-Rogers

Copper Contributor

Sep 03, 2018

Hi Sergei,

Thanks very much. I appreciate your help. Any idea why it would not work on my version?

Kind regards,

Mark

SergeiBaklan

Diamond Contributor

Sep 03, 2018

Mark, the only guess if you tried to enter the formula as

=IFERROR(N3-Q3)/N3,0)
instead of
=IFERROR((N3-Q3)/N3,0)