Explore BrainMass
Share

Excel Formula Statements Explained

I need help with the attached 3 sheets. The formula matching I need explained what and why would match each letter to each statement but does not have to be answered, I am more concerned with the formula sheets.

The other 2 sheets are formula related and I need those explained as to which formula to use and how.

Determine the AdjPay by computing the following bonus amounts.
(1) RushHour bonus is an extra $3.00 per hour for time spent driving during rush hour, from 2 PM til 6 PM.
(2) If Start Time is before 6 AM on Sunday or before 5 AM on Saturday, bonus is $30.
(3) If the average speed driven is 45 mph or less, bonus is $20. (Assume unloading at destination requires 30 Min.)

© BrainMass Inc. brainmass.com August 21, 2018, 11:22 am ad1c9bdddf

Attachments

Solution Summary

The expert examines excel formulas statements. The bonus amounts for AdjPay is determined.

$2.19