Thanks, Both formulas worked but when we copy the cell down the sheet if the
others cells are blank, then the 37.5 apears until numbers are entered. Can
the formula be "hidden" so cell is blank?

"Harlan Grove" wrote:

Peo Sjoblom wrote...
=(37.5-M6)*(M6<37.5)

will retrun zero of condition is FALSE
....

OK, but why not

=MAX(0,37.5-M6)

?