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?

Sam_S007's avatar
Sam_S007
Copper Contributor

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?

  • Sam_S007's avatar
    Sam_S007
    Copper Contributor
    Oct 21, 2020
    Thanks, that works

Resources