Assign numerical value to cell based on text in another cellClosed

Question

Hello, 
I'm trying to solve an issue...

Column A cells have a drop down which has 4 text options to choose from:
Tier 1
Tier 2
Tier 3
Tier 4

In Column B cells I'd like to automatically assign a % value associated with those 4 tiers
Tier 1 = 9%
Tier 2= 8%
Tier 3 = 5%
Tier  4 - 3%

Column C will have a manually input $ value

Column D will multiply B*C to produce a $ value

Thanks!






Configuration: Mac OS X (10.10.5) / Chrome 51.0.2704.103

Mazzaropi · Answer

ERS, Good afternoon. 
 
Suppose:
A1 --> Drop Down

At column B you can use a lot of different ways.

a) Using IF Function
 B1 --> =IF(A1="Tier 1",9%,IF(A1="Tier 2",8%,IF(A1="Tier 3",5%,3%)))

b) Using VLOOKUP Function
..........F.........G
1.....TIER 1.....9%
2.....TIER 2.....8%
3.....TIER 3.....5%
4.....TIER 4.....3%
B1 --> =VLOOKUP(A1,F1:G4,2,FALSE)

At column C you input VALUE

At column D a Formula

D1 --> =B1*C1

Is that what you want?
I hope it helps.
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Assign numerical value to cell based on text in another cell

1 response

Similar discussions

Subscribe To Our Newsletter!