"skateblade" wrote...
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?
....

=IF(ISNUMBER(M6),MAX(0,37.5-M6),"")