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



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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html