Thread: Formula Error
View Single Post
  #5   Report Post  
Mike R
 
Posts: n/a
Default

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

"Biff" wrote:

Hi!

Replace the "" with a zero.

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

Biff

-----Original Message-----
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
.