Example 1

The table indicates that if the price is at least $75 and less than $100, then the discount is 20%. Excel has a function, =vlookup(), that works similarly by returning a value from a vertically arranged table based on a lookup value. Here is its format: =vlookup(lookup value cell, lookup table, return value column) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download