Well

I think the same principal applies. What you're saying is that you want
J29 to return zero if the employee name is removed from J1, right?

in J29

=IF(J1<"",formula,0)

formula being the current formula in J29.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501505