=min(sum(A1:A50),40)
=if(sum(A1:A50)<=40,"",Sum(A1:A50)-40)
--
Regards,
Tom Ogilvy
"ryevick" wrote in
message ...
(This is for a time card) I need to add positive and negative numbers in
a column... if the value is over 40 I want to display 40 and place the
balance in the cell below as overtime hours... if it is under 40 just
display it and nothing below... Please help (pt. 1) Thanx
--
ryevick
------------------------------------------------------------------------
ryevick's Profile:
http://www.excelforum.com/member.php...o&userid=28882
View this thread: http://www.excelforum.com/showthread...hreadid=486314