If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Difference between ISNA and ISERROR
Hi all
Can anybody explain the difference between these two functions? I've created a report containing the ISNA function and a colleague has said that they would have used the ISERROR function instead. What is the difference between these two functions because if I change it to ISERROR, I get the same results any way. Thank you. Louise |
#2
|
|||
|
|||
Difference between ISNA and ISERROR
ISERROR is the superset of ISNA so you can replace ISNA with ISERROR but you
can not use ISNA in place of ISERROR Explanation: From Excel Help ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). ISNA Value refers to the #N/A (value not available) error value. Complete list of IS functions Function Returns TRUE if - ISBLANK Value refers to an empty cell. ISERR Value refers to any error value except #N/A. ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). ISLOGICAL Value refers to a logical value. ISNA Value refers to the #N/A (value not available) error value. ISNONTEXT Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.) ISNUMBER Value refers to a number. ISREF Value refers to a reference. ISTEXT Value refers to text. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Louise" wrote: Hi all Can anybody explain the difference between these two functions? I've created a report containing the ISNA function and a colleague has said that they would have used the ISERROR function instead. What is the difference between these two functions because if I change it to ISERROR, I get the same results any way. Thank you. Louise |
#3
|
|||
|
|||
Difference between ISNA and ISERROR
ISERROR tests for *any and all* of the Excel error types:
#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE! ISNA tests *only* for the #N/A error. -- Biff Microsoft Excel MVP "Louise" wrote in message news Hi all Can anybody explain the difference between these two functions? I've created a report containing the ISNA function and a colleague has said that they would have used the ISERROR function instead. What is the difference between these two functions because if I change it to ISERROR, I get the same results any way. Thank you. Louise |
Thread Tools | |
Display Modes | |
|
|