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

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

"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
.