How do I write a IF function formula?

[Guest]

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

 

[Barb Reinhardt]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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