Formula Error

M

Mike R

xl2000
My formula works fine but it has the #value! error. what do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
 
D

Debra Dalgleish

It's not clear to me what you're checking for in the IF formula. You
should be able to change this to:

=C37+D37+D36*D35
 
B

Biff

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g>

Biff
 
M

Mike R

Thanks for the return here "Biff"
Sorry I was short on good info there. the only time it return the error is
before any data is entered. once that happens it does work fine. thanks
again
 
M

Mike R

Tried your Debras solve and I still have the error without data, entered data
just to checK it and it does work. Any other ideas
 
P

Peo Sjoblom

If Debra's formula gives you an error you must have formula blanks or spaces
in the cells when they look empty
there is no way that formula can give an error on empty cells

another way

=SUM(C37:D37,IF(OR(D36="",D35=""),0,D36*D35))

change "" to space if that's what you have

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
M

Mike R

Thank you so much for your input!!! I found the space and all is well now!!!
Sometimes the right information at the right time is all it takes.
 
Top