# Lab 3.4 - (i.e the value happens to be an actual boundary...

This preview shows pages 1–4. Sign up to view the full content.

Comments Page 1 Comments - Ratings by Lookup The Data worksheet in this example contains a simple column of numbers in the Values column. The aim is to associate with each number a rating - say "very high", "high", "middle", etc. Perhaps these numbers are scores on some kind of test, for example. It is possible to do this using an if function - but if there are many ratings categories the if function becomes very unwieldy. In fact nested if functions have a limit of about 7 functions. The better way to do this is to use a LOOKUP function. You need to construct separately the data that the function will "look up". In this case you need a table of numbers defining the boundaries of the ratings along with the associated rating. The LOOKUP function takes a value from the Data worksheet (call it the search value) and searches for that value in the boundary values that you have put in the lookup table. If it finds the value

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (i.e. the value happens to be an actual boundary value) the function returns the associated rating, and if it doesn't find it the function returns the rating associated with the largest boundary value that is less than the search value. After you have built the lookup table and the formula be sure to experiment with it so that you fully understand the description in the previous paragraph of how the function works. Comments Page 2 s Lookup Page 3 Rating very high 5 high 8 middle 11 low 15 very low Boundary Value Data Page 4 Values Rating 9 middle 4 very high 12 low 8 middle 11 low 4 very high 2 very high 7 high 5 high 1 very high 10 middle 5 high 14 low 8 middle 9 middle 6 high 8 middle 10 middle 8 middle 9 middle 11 low 6 high 12 low 8 middle 10 middle 10 middle 9 middle 15 very low 11 low 4 very high 7 high...
View Full Document

## This note was uploaded on 02/05/2011 for the course ECON 1000 taught by Professor Paschakis during the Spring '08 term at York University.

### Page1 / 4

Lab 3.4 - (i.e the value happens to be an actual boundary...

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

View Full Document
Ask a homework question - tutors are online