Link to home
Start Free TrialLog in
Avatar of sonmic
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
Avatar of helpfinder
helpfinder
Flag of Slovakia image

yes.
use IFERROR formula, e.g. =IFERROR(IF(B1='c'!A1;1;2);"UUPS")
ASKER CERTIFIED SOLUTION
Avatar of Eirman
Eirman
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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+b1)