How to deal with "#N/A"???

[Graeme]

I am trying to run an IF statement associated with a
column of values I've generated in Excel 97.

The column is essentially a lookup result. If it has not
found a value, then it displays "N/A".

I can't carry out calculations on this. I want to have an
IF statement that says "If the value of this column
is "N/A" take the value in the adjacent column, otherwise
take the value of this column".

I've tried =IF(A1="#N/A",B1,A1) - Didn't work.

I saw that there is a field "ERROR.TYPE", so I then
tried "=IF(ERROR.TYPE(a1)=7,B1,A1)" This returned the
adjacent column value if "N/A" was true, but
returned "N/A" if the value of A1 was not "N/A".

Any ideas please?

 

[Dan E]

Graeme,

Try using ISERROR

ie. =IF(ISERROR(A1),B1,A1)

Dan E

 

[John Wilson]

Graeme,

The basic construct would be as follows:

=IF(ISNA(yourlookup),0,yourlookup)

From your post, maybe something like:

=IF(ISNA(yourlookup),someotherlookup,yourlookup)

John