software

I need to write a formula for the following but am confused as to how to do
it. Can someone help?

1. determine gross pay in column F as follows:
a. In cell F4, enter an IF function that applies the following logic and
then copy it to the range F5:F10.
If hours lt;= 40, then Rate * Hours, otherwise Rate * Hours 0.5 * (Hours -
40)

b. In cell I4, enter the IF function that applies the following logic:
If (Gross Pay - Dependents * 38.46) gt; 0, then 20% * (Gross Pay -Dependents
* 38.46), otherwise 0

What columns are used for Rate, Hours, Gross Pay and Dependents?

quot;JulieA60quot; gt; wrote in message
...
gt;I need to write a formula for the following but am confused as to how to do
gt; it. Can someone help?
gt;
gt; 1. determine gross pay in column F as follows:
gt; a. In cell F4, enter an IF function that applies the following logic and
gt; then copy it to the range F5:F10.
gt; If hours lt;= 40, then Rate * Hours, otherwise Rate * Hours 0.5 * (Hours -
gt; 40)
gt;
gt; b. In cell I4, enter the IF function that applies the following logic:
gt; If (Gross Pay - Dependents * 38.46) gt; 0, then 20% * (Gross
gt; Pay -Dependents
gt; * 38.46), otherwise 0
The general format of the formula you require would be:

=IF(Hourslt;=40,Rate*Hours,Rate*Hours 0.5*(Hours-40))

The values for Hours and Rate can either be stoed in cells or replaced with
the actual amount required e.g. Hours in cell E4 and rate in cell D4:

=IF(E4lt;=40,D4*E4,D4*E4 0.5*(E4-40))

The second formula, will be similar but, presumably using the gross pay
calculated as above:

=IF((F4-Dependents*38.46)gt;0,(F4-Dependents*38.46)*20%,0)

again, dependents will either be the cell reference or a value

HTH

quot;JulieA60quot; wrote:

gt; I need to write a formula for the following but am confused as to how to do
gt; it. Can someone help?
gt;
gt; 1. determine gross pay in column F as follows:
gt; a. In cell F4, enter an IF function that applies the following logic and
gt; then copy it to the range F5:F10.
gt; If hours lt;= 40, then Rate * Hours, otherwise Rate * Hours 0.5 * (Hours -
gt; 40)
gt;
gt; b. In cell I4, enter the IF function that applies the following logic:
gt; If (Gross Pay - Dependents * 38.46) gt; 0, then 20% * (Gross Pay -Dependents
gt; * 38.46), otherwise 0

The columns are as follows:
B - Rate
C - Hours
D - Dependents
F - Gross Pay
quot;Barb Reinhardtquot; wrote:

gt; What columns are used for Rate, Hours, Gross Pay and Dependents?
gt;
gt; quot;JulieA60quot; gt; wrote in message
gt; ...
gt; gt;I need to write a formula for the following but am confused as to how to do
gt; gt; it. Can someone help?
gt; gt;
gt; gt; 1. determine gross pay in column F as follows:
gt; gt; a. In cell F4, enter an IF function that applies the following logic and
gt; gt; then copy it to the range F5:F10.
gt; gt; If hours lt;= 40, then Rate * Hours, otherwise Rate * Hours 0.5 * (Hours -
gt; gt; 40)
gt; gt;
gt; gt; b. In cell I4, enter the IF function that applies the following logic:
gt; gt; If (Gross Pay - Dependents * 38.46) gt; 0, then 20% * (Gross
gt; gt; Pay -Dependents
gt; gt; * 38.46), otherwise 0
gt;
gt;
gt;

Thanks bigwheel for your reply. I'm going to give this a try and let you know
if I've finally caught on

quot;bigwheelquot; wrote:

gt; The general format of the formula you require would be:
gt;
gt; =IF(Hourslt;=40,Rate*Hours,Rate*Hours 0.5*(Hours-40))
gt;
gt; The values for Hours and Rate can either be stoed in cells or replaced with
gt; the actual amount required e.g. Hours in cell E4 and rate in cell D4:
gt;
gt; =IF(E4lt;=40,D4*E4,D4*E4 0.5*(E4-40))
gt;
gt; The second formula, will be similar but, presumably using the gross pay
gt; calculated as above:
gt;
gt; =IF((F4-Dependents*38.46)gt;0,(F4-Dependents*38.46)*20%,0)
gt;
gt; again, dependents will either be the cell reference or a value
gt;
gt; HTH
gt;
gt; quot;JulieA60quot; wrote:
gt;
gt; gt; I need to write a formula for the following but am confused as to how to do
gt; gt; it. Can someone help?
gt; gt;
gt; gt; 1. determine gross pay in column F as follows:
gt; gt; a. In cell F4, enter an IF function that applies the following logic and
gt; gt; then copy it to the range F5:F10.
gt; gt; If hours lt;= 40, then Rate * Hours, otherwise Rate * Hours 0.5 * (Hours -
gt; gt; 40)
gt; gt;
gt; gt; b. In cell I4, enter the IF function that applies the following logic:
gt; gt; If (Gross Pay - Dependents * 38.46) gt; 0, then 20% * (Gross Pay -Dependents
gt; gt; * 38.46), otherwise 0