Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (A24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40.

6carla would like to buy a dress, a dresser for her bedroom, and a home theater system. she has one month's worth of living expenses in her emergency fund. carla decides to save for the home theater system. did carla make the right decision? why or why not? a. yes; her emergency fund is full and the other items will probably be less expensive. b. yes; she could save more for her emergency fund, but the home theater will be harder to save for. c. no; she should save more for her emergency fund because she has saved less than the recommended amount. d. no; she should have bought the dress and dresser first because she could afford them right away. reset next