Formula Help
Posted by Chad on November 22, 2001 1:50 PM
This is the formula in my own words:
If B24<100 then B2*.25, If B24 is between 100-499, then
B2*.19, If B24 is between 500-999, then B2*.17, If B24 is between 1000-4999, Then B2*.16, If B24 is between
5000-9999, Then B2*.14, If B24 is between 10,000-19,999
Then B2*.13, If B24>= 20,000, Then B2*.12
Thanks so much for any help you can provide.
Posted by Aladin Akyurek on November 22, 2001 2:20 PM
=IF(ISNUMBER(B4),B2*VLOOKUP(B24,{0,.25;100,.19;500,.17;1000,.16;5000,.14;10000,.13;20000,.12},2),"")
Note. You can also create a 2-column table from
{0,.25;100,.19;500,.17;1000,.16;5000,.14;10000,.13;20000,.12}
in some range and use that range in the above formula.
Aladin
Posted by Chad on November 22, 2001 4:39 PM
Thank you Aladin!!
