software

ok heres my problem

i have a sheet working out my wages (only an est.) but it does most of the
math for me ie tax payment, total with over time without deductions etc BUT i
want the over time cell to work out my overtime rate ONLY if the total hour
sheet and the total hour cell minues lunch break cell read 40 is this
possable or am i asking to much off the spred sheet? (this saves data input
in the long run)



quot;Seanquot; wrote:

gt; ok heres my problem
gt;
gt; i have a sheet working out my wages (only an est.) but it does most of the
gt; math for me ie tax payment, total with over time without deductions etc BUT i
gt; want the over time cell to work out my overtime rate ONLY if the total hour
gt; sheet and the total hour cell minues lunch break cell read 40 is this
gt; possable or am i asking to much off the spred sheet? (this saves data input
gt; in the long run)oh here are my formulas

=SUM(D1620) lt;lt;total hours
=SUM(E16:E20) lt;lt; total hours after lunch break removed
=SUM(B23-40) lt;lt; Overtime hours worked out from formula above
=SUM(B25*10.5) lt;lt; overtime pay from hours worked out by overtime hour formula

as you can tell im very limited with exel


I'm assuming you have hours in decimal format not time format.....

If you change your 3rd formula to

=MAX(B23-40,0)

then when B23 is less than 40 the result of this formula will be zero
so the next formula...

=SUM(B25*10.5)

will also return a zero.

In that last formula you don't need the SUM function, this will
suffice

=B25*10.5--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528884Change

=SUM(B23-40)

to

=MAX(B23-40,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Seanquot; gt; wrote in message
...
gt;
gt;
gt; quot;Seanquot; wrote:
gt;
gt; gt; ok heres my problem
gt; gt;
gt; gt; i have a sheet working out my wages (only an est.) but it does most of
the
gt; gt; math for me ie tax payment, total with over time without deductions etc
BUT i
gt; gt; want the over time cell to work out my overtime rate ONLY if the total
hour
gt; gt; sheet and the total hour cell minues lunch break cell read 40 is this
gt; gt; possable or am i asking to much off the spred sheet? (this saves data
input
gt; gt; in the long run)
gt;
gt;
gt; oh here are my formulas
gt;
gt; =SUM(D1620) lt;lt;total hours
gt; =SUM(E16:E20) lt;lt; total hours after lunch break removed
gt; =SUM(B23-40) lt;lt; Overtime hours worked out from formula above
gt; =SUM(B25*10.5) lt;lt; overtime pay from hours worked out by overtime hour
formula
gt;
gt; as you can tell im very limited with exel

thanks guys big big big help