Thanks, but it didn't work . Again, 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?


"Peo Sjoblom" wrote:

=IF(M8="","",MAX(0,37.5-M8)

--
Regards,

Peo Sjoblom

(No private emails please)


"skateblade" wrote in message
...
We are doing a time card and have this formula: =MAX(0,37.5-M8) when we
insert the formula in the cell and theres no hours for that pay period it
shows 37.5 how can we hide the formula so the cell is blank.