=if help please!

  • Thread starter Thread starter kba11
  • Start date Start date
K

kba11

I want a cell (G5) to say no when another cell contains #N/A, is this
possable and if so how?

This iswhat I tryed...

=IF(G5="#N/A","NO","NO")

Thanks
Rob T
 
Hi Rob

=IF(ISNA(G5),"NO","NO")

But I suppose You did not mean "G5" but "another cell" and I suppose you
didn't want the answer to be "NO" in both cases.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
#N/A means that no value is available. The formula may
contain a function that has a missing or inappropriate
argument or has a reference to a blank cell.
 
I want a cell (G5) to say no when another cell contains #N/A, is this
possable and if so how?

This iswhat I tryed...

=IF(G5="#N/A","NO","NO")

Thanks
Rob T
Click to expand...

If #N/A is the error value that Excel may generate,then try this:

=IF(ISNA(G5),"No","Yes")


--ron
 
Back
Top