Tue, 8 May 2007 08:34:02 -0700 from JerryS
:
Using the following table, I want a formula that satifies multiple IF type
statements.
From To MTM Renew 10
0 30 $32.39 $17.60
31 100 $31.94 $15.35
101 225 $31.04 $14.00
226 450 $30.59 $12.20
451 1000 $29.24 $10.40
For example, if one value is greater than 101 and less than 225, the value
is $31.04.
Use VLOOKUP with the fourth argument set to TRUE.
You don't need your first column at all, assuming it's impossible for
your input value to be less than 0.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/