Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
if function
0 views
Skip to first unread message
Long Island Bob
May 30, 2003, 11:03:39 AM5/30/03
to
hello anyone. i have a formula:
=if(n23="#n/a","",n23)
my problem is the cell, and others, have "#n/a" in them.
It seems that it is not identifying the "#n/a".
if a have "#n/a" in the cell it returns "#n/a" instead of
spaces. if there is something else in the cell it leaves
it alone. Anyone have a clue?? Thanks, bob
Anon
May 30, 2003, 11:39:35 AM5/30/03
to
"Long Island Bob" <bsa...@nesenergy.com> wrote in message
news:077b01c326bc$a707a8b0$a001...@phx.gbl...
news:077b01c326bc$a707a8b0$a001...@phx.gbl...
Your formula is looking for the text "#n/a", which is not the same as the
'not-available' value that excel displays as #N/A. Try this:
=IF(ISNA(N23),"",N23)
0 new messages