Adjust multiplier per range

[eblack93]

Good day, I would like to multiply a cell's value based on a price range. For instance:

Prices from $0 - $49 the multiplier should be x1
Prices from $50 - $99 the multiplier should be x1.125
Prices from $100 - $199 the multiplier should be x1.2
Prices from $200 - $1999 the multiplier should be x1.5
Prices from $2000 and above, the multiplier should be x1.25

Any ideas on which formulas should I use? Thanks!

 

[Fluff]

You could use a lookup table like

+Fluff 1.xlsm
	A	B	C	D	E
1
2	110	132		0	1
3				50	1.125
4				100	1.2
5				200	1.5
6				2000	1.25
Master

Cell Formulas
Range	Formula
B2	B2	=A2*VLOOKUP(A2,D2:E7,2,1)

Although your final multiplier looks wrong