lab 3 exercise 1 - Comments Comments TheSales_...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Comments Page 1 Comments The Sales_Record worksheet contains the names of sales people and the dollar amount of sales they have made. These might be real estate sales people or commercial sales people for  example. This model will lead you through the creation of an if function. The if function will return as its result one of two possible answers depending on whether some condition is true or false. In this case the condition is "did the salesperson make sales greater than the average?". If the answer to this condition is true you want to have the words "Equal/Above" appear in a new  column in the row for that salesperson. If the condition is false you want the word "Below" to appear. The new column might be titled "Compared to Average". The if function has the template: IF(logical_test, value_if_true, value_if_false) Notice that there are three arguments. The logical_test argument in the example we're 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Page1 / 2

lab 3 exercise 1 - Comments Comments TheSales_...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online