Functions
 

a1 has a employees name in it, but when i remove the name i want j1 to read 0
hours.

Functions
 

Is there currently a formula in J1? If so then maybe you could change it
to

=IF(A1<"",formula,"0 hours")

where formula is your current formula in J1


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

Functions
 

No formula in J1 just the name, but in J28 i have the sum for five days work
and in J29 the sub total that will carrie over to next. So if i remove the
name i did not want the hours to carrie over. This is a over time list that
runs for sixteen week. If a person want off the list, i need is time to stop.

"daddylonglegs" wrote:


Is there currently a formula in J1? If so then maybe you could change it
to

=IF(A1<"",formula,"0 hours")

where formula is your current formula in J1


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

Functions
 

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

Functions
 

Have you got a E-mail address, i'll send you a copy.

"daddylonglegs" wrote:


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