If statement on cell with #N/A

C

ChrisMattock

I have a cell that returns a value #N/A if information is not available
I need to do an If statement to see if this cell has #N/A in it, but i
I do =IF(A1="#N/A","TRUE","FALSE") it doesn't work. Any ideas
 
B

Bondi

Hi Chris,

Maybe you can use something like:

=IF(ISNA(A1),"TRUE","FALSE")

Regards,
Bondi
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi


„ChrisMattock†ezt írta:
 
Top