Hi all,
How to get #N/A in IF function to return to 1?
This is the formula:
=IF(A1=#N/A,1,2)
The result always return to #N/A. Use text but same result.
I dont understand this
Is there something missing here?
Hi all,
How to get #N/A in IF function to return to 1?
This is the formula:
=IF(A1=#N/A,1,2)
The result always return to #N/A. Use text but same result.
I dont understand this
Is there something missing here?
Use
=IF(ISNA(A1),1,2)
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks. It works.
or else can use =--ISNA(a1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks