Iserror

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

This is my current formula =IF(B3>D3,"",D3-B3) But I need to add the
ISERROR because I'm getting the #VALUE! message. Can't figure out how
to add it to this formula and keep the same results. Thanks in
advance!!!
 
excel 2007+     =iferror(IF(B3>D3,"",D3-B3) ,"")

or
        =if(iserror(IF(B3>D3,"",D3-B3),"",IF(B3>D3,"",D3-B3) )

Better would be to determine why you are getting the VALUE error, and
test for that alone.
Click to expand...

Still will not work? Why the error shows up is untill I put something
in B3 (it's nothing). Thanks for your help!!
 
excel 2007+     =iferror(IF(B3>D3,"",D3-B3) ,"")
or
        =if(iserror(IF(B3>D3,"",D3-B3),"",IF(B3>D3,"",D3-B3) )
Click to expand...
[....]
Still will not work?
Click to expand...

Exactly what does not work?! Ron gave you two things to try. You do
not tell us what you tried.

No matter. There really is no way either could "not work" (i.e.
avoid the #VALUE error) if you entered it correctly. You should copy-
and-paste from the Formula Bar into a follow-up posting to show us
exactly what you entered.

In any case, as Ron said, let's fix the #VALUE problem and avoid the
ISERROR or IFERROR kludge.

My guess: D3 contains text -- perhaps the null string (""), in which
case D3 __appears__ blank, but it is not empty.

Going back to your original formula, try:

=IF(OR(B3="",D3="",B3>D3),"",D3-B3)

Be sure to copy-and-paste this (and any) formula that we provide from
the posting into the Formula Bar.

That returns the null string ("") instead of D3 as your original
formula did if B3 is truly empty (no constant and no formula). If
that is your intention, we can fix that.
 
Back
Top