Stefi wrote:
A9: =MIN(SUM(A1:A7),40)
A10: =MAX(0,SUM(A1:A7)-40)
Regards,
Stefi
"mike" ezt írta:
I am trying to make a simple timesheet, if I figure it out a little
better I will expand it, that will add over time. I just want to
add up the 7 days, cells A1-A7 and put that total in cell A9
{=SUM(A1:A7)} in cell A10 I would like it to not do anything until
columns A1-A7 go over 40, I would then like the number 40 to stay at
40 in cell A9 then put anything over that in cell
A10{=SUMIF(A9,"40")-40} sort of like this. Is their a way to keep
the "-40" in cell A10 "invisable" until it goes over 0? And to stop
the 40 in cell A9 from going over 40? Thanks.
Thanks!!
|