sonmic
asked on
#REF!
Hi,
Can i change, when i have in a cell the result #REF!, it to 0 or Null (like #N/A)?
Tx
Can i change, when i have in a cell the result #REF!, it to 0 or Null (like #N/A)?
Tx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you need to use the IF() and ISERR() combination for #DIV/0 or #REF error's
if you get #N/A then you need to use ISNA() function....
i.e.: =IF(ISERR(a1+b1),0,a1+b1) or IF(ISNA(a1+b1),"Null",a1+b 1)
if you get #N/A then you need to use ISNA() function....
i.e.: =IF(ISERR(a1+b1),0,a1+b1) or IF(ISNA(a1+b1),"Null",a1+b
use IFERROR formula, e.g. =IFERROR(IF(B1='c'!A1;1;2)