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