Forum Discussion

Sam_S007

Copper Contributor

Oct 16, 2020

Solved

Excel IF Formula

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

IF FORMULA.xlsx36 KB

office 365

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

Copper 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

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.

IFERROR FORMULA.xlsx30 KB

BradD
Copper 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
  Copper Contributor
  Oct 21, 2020
  Thanks, that works