Progressive Rate in Excel

[kuhasu]

Greetings,
I need help, I want to make like this situation

range value
10 - 20 35
21 - 30 45
31 - 40 55
41 - 50 65

How can I make like this, BTW, thank u very much !


Kuhas

 

[Dave R.]

I'm sure someone else has a better idea what you're doing; but this will
return the values as given in your table;

A1 contains '10-20
in B1 put
=MID(A1,FIND("-",A1)+1,999)+15

excel will try to read it as a date, so format as a number.

 

[Peo Sjoblom]

Maybe this is what you want

http://www.mcgimpsey.com/excel/variablerate.html

if the rates are not variable then you can use a simple lookup

A B
0 0
10 35
20 45
30 55
40 65

create a table like the above, then use a formula like

=LOOKUP(lookup_value,A1:A5,B1:B5)

 

[Gord Dibben]

Kuhasu

One method.....

=LOOKUP(A1,{10;21;31;41},{35;45;55;65})

Gord Dibben Excel MVP