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 <= 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) 0, then 20% * (Gross Pay -Dependents
* 38.46), otherwise 0

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

"JulieA60" wrote in message
...
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 <= 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) 0, then 20% * (Gross
Pay -Dependents
* 38.46), otherwise 0

The general format of the formula you require would be:

=IF(Hours<=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(E4<=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)0,(F4-Dependents*38.46)*20%,0)

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

HTH

"JulieA60" wrote:

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 <= 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) 0, then 20% * (Gross Pay -Dependents
* 38.46), otherwise 0

The columns are as follows:
B - Rate
C - Hours
D - Dependents
F - Gross Pay



"Barb Reinhardt" wrote:

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

"JulieA60" wrote in message
...
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 <= 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) 0, then 20% * (Gross
Pay -Dependents
* 38.46), otherwise 0

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

"bigwheel" wrote:

The general format of the formula you require would be:

=IF(Hours<=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(E4<=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)0,(F4-Dependents*38.46)*20%,0)

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

HTH

"JulieA60" wrote:

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 <= 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) 0, then 20% * (Gross Pay -Dependents
* 38.46), otherwise 0