#value!

A

alexm999

I have the following formula in my cell:

=IF(D13<>"DMO",F12+E13,F12)

when there is nothing inputed, I get a #VALUE! in the cell. Is there
way to get rid of that #VALUE from showing up in the cell???
I'd like it to be blank
 
B

Bob Phillips

=IF(ISERROR(IF(D13<>"DMO",F12+E13,F12)),"",IF(D13<>"DMO",F12+E13,F12))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
S

Sandy Mann

Bob,

The OP's formula and yours both return 0 for me if everything is blank. The
only way that I can get the OP formula to return #Value! is to *blank* out a
cell with a space. In that case your formula does hide the error.

To the OP
It not very elegant but try:

=IF(D13<>"DMO",F12+E13,IF(AND(D13="DMO",ISBLANK(F12)),"",F12))

and if I am right about *blanking* out cells with spaces, teach your users
to use the Delete key

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


Bob Phillips said:
=IF(ISERROR(IF(D13<>"DMO",F12+E13,F12)),"",IF(D13<>"DMO",F12+E13,F12))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top