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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 03, 2018

Hi Mark,

 

If you attach the sample file with error it'll be easier to understand what's wrong with your variant of the formula. In general it's correct. IFERROR has two arguments separated by comma (if you are on English SKU of Excel)

first argument: (N3-Q3)/N3
second argument 0

entire function
=IFERROR((N3-Q3)/N3,0)

In attached file I put that formula in R3 and formatted as %, it works

Mark Norris-Rogers's avatar
Mark Norris-Rogers
Copper Contributor
Sep 03, 2018

Hi Sergei,

 

Thanks again for your reply. I have attached a sample spreadsheet for you to check. I can’t save it with the IFERROR formula as it keeps giving the formula error message or “too few arguments”message.

 

Kind regards,

 

Mark

    • 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)