software

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


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

=IF(A1lt;gt;quot;quot;,formula,quot;0 hoursquot;)

where formula is your current formula in J1--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501505No 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.

quot;daddylonglegsquot; wrote:

gt;
gt; Is there currently a formula in J1? If so then maybe you could change it
gt; to
gt;
gt; =IF(A1lt;gt;quot;quot;,formula,quot;0 hoursquot;)
gt;
gt; where formula is your current formula in J1
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=501505
gt;
gt;


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(J1lt;gt;quot;quot;,formula,0)

formula being the current formula in J29.--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501505Have you got a E-mail address, i'll send you a copy.

quot;daddylonglegsquot; wrote:

gt;
gt; Well
gt;
gt; I think the same principal applies. What you're saying is that you want
gt; J29 to return zero if the employee name is removed from J1, right?
gt;
gt; in J29
gt;
gt; =IF(J1lt;gt;quot;quot;,formula,0)
gt;
gt; formula being the current formula in J29.
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=501505
gt;
gt;