« Financial Functions: CUMIPMT & CUMPRINC | Main | Rounding to the nearest nickel: MROUND() »
April 06, 2005
Looking up data in tables V
Here is another simple application of the VLOOKUP function. Consider a sales person who gets paid commissionson sales based on a sliding scale.For sales up to $50, a comission of 25% is paid, between $50 and $100, the commission drops to 22.5% - and so on. By using the lookup table and VLOOKUP, the correct rate of commission can be applied to each sale.
Posted by Dave at April 6, 2005 10:41 PM