R
Roy
a1 has a employees name in it, but when i remove the name i want j1 to read 0
hours.
hours.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
daddylonglegs
Is there currently a formula in J1? If so then maybe you could change i
to
=IF(A1<>"",formula,"0 hours")
where formula is your current formula in J
to
=IF(A1<>"",formula,"0 hours")
where formula is your current formula in J
R
Roy
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.
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.
D
daddylonglegs
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.
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.
R
Roy
Have you got a E-mail address, i'll send you a copy.