Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function with #N/A error
Does anyone know if it is possible to use the IF function with a cell
containing the #N/A error? Specifically, I want to do something on the following lines: =IF(A3=#N/A,B3,C3) because the error in A3 is sometimes expected. |
#2
|
|||
|
|||
=IF(ISNA(A3),B3,C3)
-- Return email address is not as DEEP as it appears "Roccobarocco" wrote in message ... Does anyone know if it is possible to use the IF function with a cell containing the #N/A error? Specifically, I want to do something on the following lines: =IF(A3=#N/A,B3,C3) because the error in A3 is sometimes expected. |
#3
|
|||
|
|||
=IF(ISNA(A3),B3,C3)
"Roccobarocco" wrote in message ... Does anyone know if it is possible to use the IF function with a cell containing the #N/A error? Specifically, I want to do something on the following lines: =IF(A3=#N/A,B3,C3) because the error in A3 is sometimes expected. |
#4
|
|||
|
|||
Try:
=IF(ISNA(A3),B3,C3) tj "Roccobarocco" wrote: Does anyone know if it is possible to use the IF function with a cell containing the #N/A error? Specifically, I want to do something on the following lines: =IF(A3=#N/A,B3,C3) because the error in A3 is sometimes expected. |
#5
|
|||
|
|||
Thanks, guys. Much appreciated.
"Roccobarocco" wrote: Does anyone know if it is possible to use the IF function with a cell containing the #N/A error? Specifically, I want to do something on the following lines: =IF(A3=#N/A,B3,C3) because the error in A3 is sometimes expected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
compile error: expected variable or function | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
#REF error | Excel Worksheet Functions | |||
XIRR Function Error | Excel Worksheet Functions |