Purchase Solution

Excel Formula Statements Explained

Not what you're looking for?

Ask Custom Question

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.)

Attachments
Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.