Forum Discussion

Sam_S007's avatar
Sam_S007
Copper Contributor
Oct 16, 2020

Excel IF Formula

The IF Formula in the attached spreadsheet doesn't recognize "#N/A"

office 365
  • BradD's avatar
    BradD
    Oct 20, 2020

    Sam_S007 if I understand what you're wanting to do then change the formula in C8 from this ...

       =IFERROR(B8,B7)

    ... to this ...

       =IFERROR(B8,C7)

    ... and fill all the way down.  Does that now do what you want?

  • BradD's avatar
    BradD
    Brass Contributor
    Oct 16, 2020
    #N/A is an error. Use a formula like ISERROR or IFERROR to evaluate it, you can’t just evaluate it is = “N/A”.
    • Sam_S007's avatar
      Sam_S007
      Copper Contributor
      Oct 19, 2020

      BradD 

       

      I tried using the IFERROR formula but there is still a problem.  Column B returns a number. Sometimes that number is an error. Whenever it returns an error I want to use the previous number it returned (same column, previous row). So I wrote the following formula in the adjacent column:  =IFERROR(B8,B7). But it doesn't seem to work.

       

      I attached the file below.

       

      • BradD's avatar
        BradD
        Brass Contributor
        Oct 20, 2020

        Sam_S007 if I understand what you're wanting to do then change the formula in C8 from this ...

           =IFERROR(B8,B7)

        ... to this ...

           =IFERROR(B8,C7)

        ... and fill all the way down.  Does that now do what you want?

Resources