or

=IF(B740,(B7-40)*30,"")

?

Dave O Wrote:
Try changing your formula to
=IF(B740,B7-40*30,"")

The cell will be blank until you work more than 40 hours.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=479312