SOLVED

Excel IF Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1786662%22%20slang%3D%22en-US%22%3EExcel%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786662%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20IF%20Formula%20in%20the%20attached%20spreadsheet%20doesn't%20recognize%20%22%23N%2FA%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787123%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787123%22%20slang%3D%22en-US%22%3E%23N%2FA%20is%20an%20error.%20Use%20a%20formula%20like%20ISERROR%20or%20IFERROR%20to%20evaluate%20it%2C%20you%20can%E2%80%99t%20just%20evaluate%20it%20is%20%3D%20%E2%80%9CN%2FA%E2%80%9D.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795187%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IF%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702117%22%20target%3D%22_blank%22%3E%40BradD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20using%20the%20IFERROR%20formula%20but%20there%20is%20still%20a%20problem.%26nbsp%3B%20Column%20B%20returns%20a%20number.%20Sometimes%20that%20number%20is%20an%20error.%20Whenever%20it%20returns%20an%20error%20I%20want%20to%20use%20the%20previous%20number%20it%20returned%20(same%20column%2C%20previous%20row).%20So%20I%20wrote%20the%20following%20formula%20in%20the%20adjacent%20column%3A%26nbsp%3B%20%3DIFERROR(B8%2CB7).%20But%20it%20doesn't%20seem%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20the%20file%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

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

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

 

Highlighted
Best Response confirmed by Sam_S007 (Occasional Contributor)
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?

Highlighted
Thanks, that works