[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

#REF!

Hi,

Can i change, when i have in a cell the result #REF!, it to 0 or Null (like #N/A)?

Tx
0
sonmic
Asked:
sonmic
1 Solution
 
helpfinderIT ConsultantCommented:
yes.
use IFERROR formula, e.g. =IFERROR(IF(B1='c'!A1;1;2);"UUPS")
0
 
EirmanChief Operations ManagerCommented:
IFERROR will nor work in excel 2003. It works in excel 2007 & 2010

Use IF and ISERROR in combination
http://www.excel-examples.com/iserror.htm

or

Use this really excellent excel add-on for painless error handling (there is a free home use version)
http://www.asap-utilities.com/
0
 
wshark83Commented:
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)
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now