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