Forum Discussion

Mark Norris-Rogers's avatar
Mark Norris-Rogers
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's avatar
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's avatar
    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)

     

Resources