Excel IF Formula

[Sam_S007]

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

[#2]

#N/A is an error. Use a formula like ISERROR or IFERROR to evaluate it, you can’t just evaluate it is = “N/A”.

[#3]

@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.

[#4 · Accepted solution]

@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?

[#5]

Thanks, that works