Explore BrainMass
Share

Explore BrainMass

    Excel Formula Statements Explained

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 9, 2019, 7:23 pm ad1c9bdddf
    https://brainmass.com/computer-science/software-development/excel-formula-statements-explained-116504

    Attachments

    Solution Summary

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

    $2.19