(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

assuming cells B21 & B22

B21: =MIN(40,SUM(B1:B20))
B22: =IF(SUM(B1:B20)40,SUM(B1:B20)-40,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

=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