This is wierd. This formula should return #VALUE! only if G12 contains
a non-numeric value. If there is NO value, a blank cell would count as
0. Is there a chance that you type a space character in the cell?

At any rate, try the equivalent formula

=MAX(G12-40, 0)

and see what happens.

HTH
Kostis Vezerides