Multiplying based on value

[jeremyjohnson]

I have a column of totals that I need to multiply by different numbers based on their value.

Units that sold $1 to $4,999 in 2015 and increase sales by 20%
Units that sold $5,000 to $9,999 in 2015 and increase sales by 15%
Units that sold $10,000+ in 2015 and increase sales by 10%

I really don't know where to begin. I have tried several IF statements, but I can't seem to get it correct.

Thank you all for any help you can provide. This may be simple for you but I am ready to bang my head against a wall.

 

[sheetspread]

Excel 2010
	A	B	C	D	E
1				0	0.2
2	2080	0.2		5000	0.15
3	10000	0.1		10000	0.1
4	8558	0.15
5	4568	0.2
6	5548	0.15
7	1283	0.2
8	17394	0.1
9	9999	0.15
10	1173	0.2
11	493	0.2
12	7716	0.15
13	5000	0.15
14	499	0.2
15	15240	0.1
16	677	0.2
17	2166	0.2
18	4999	0.2
19	8710	0.15
20	18303	0.1
Sheet6

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,$D$1:$E$3,2,1)

the formula can hold the array also

 

[jeremyjohnson]

Thank you, I understand how to do that, but I need to have a formula that does all of that behind the scenes based on the numbers that are entered.

I need the formula to determine that the cell falls in the range of 1-4999 and then if it does to multiply it by 1.2. If it is between falls between 5000-9999 to multiply if by 1.15 and if it is greater than 9999 to multiply if by 1.1.

I need the formula to do those calculations behind the scenes.

 

[sheetspread]

This?

Excel 2010
	A	B
2	2080	2496
3	10000	11000
4	8558	9841.7
5	4568	5481.6
6	5548	6380.2
7	1283	1539.6
8	17394	19133.4
9	9999	11498.85
10	1173	1407.6
11	493	591.6
12	7716	8873.4
13	5000	5750
14	499	598.8
15	15240	16764
16	677	812.4
17	2166	2599.2
18	4999	5998.8
19	8710	10016.5
20	18303	20133.3
Sheet6

Cell Formulas
Range	Formula
B2	=A2*(1+VLOOKUP(A2,{0,0.2;5000,0.15;10000,0.1},2,1))

 

[jeremyjohnson]

You sir or ma'am are amazing! I thank you so much!