Excell
 

Does anyone no how to set a formula to do this,
there is different ranges like 0-499,500-799,800-999 and with each range
there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
Mike

Excell
 

=LOOKUP(B1,{0,500,800,1000},{0.01,0.02,0.03})*B1


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 11:28:15 -0800, americasmattress8888
wrote:

Does anyone no how to set a formula to do this,
there is different ranges like 0-499,500-799,800-999 and with each range
there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
Mike