Assign numerical value to cell based on text in another cell [Closed]

Report
-
Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
-
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!






1 reply

Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
143
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!