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 missing it?

 

Thanks

Formulas and Functions

7 Replies

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

      Hi Sergei,

       

      Thanks very much for your response. I downloaded your example. However, when I tried it in my spreadsheet it gave an error message:

      "You've entered too few arguments for this function."

       

      I noticed your formula did not include a comma between the calculation (N3-Q3)/N3 and the 0, although in the Help example there was one. If I did add a comma, it gave the general formula error message (i.e. "There's a problem with this formula."Not trying to type a formula etc..). 

      Excel highlighted the second N3 and 0 in grey after I got the initial error message (i.e. highlighting it had a problem there). 

       

      The result of my formula must be in Column R, i.e.  R3 = (N3-Q3)/N3, where Column R is formatted as % with 1 decimal point. If I copied the formula in your example to R3 it gives the "too few arguments"message. Is there a circular reference error If I do this?

       

      I have tried IF and IFERROR formulae, but both give these same errors, and I cannot see where the problem lies!

       

      Thanks again,

       

      Mark

      • 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

Resources