"Ragdyer" wrote in message
...
What's in G40 and F39?

You say they're *both blank*, but F39 is returning a #Value! error!
How can it be *both ways*?
Do they contain formulas?
A #Value! error can come from a formula performing calcs on a cell
containing text.

--
Regards,

RD

G40 is my the tax rate of 7.375% and F39 is
=IF(SUM(F18:F38)0,SUM(F18:F38),"")

What I am doing is multiply my tax rate times the subtotal. If the
spreadsheet is blank without any values, then it WAS returning a #value!
error message. I have since cleaned up the formula in cell F40 with this
formula:
=IF(ISERROR(F39*G40),"",(F39*G40))