Assign numerical value to cell based on text in another cell
Closed
ERS
-
Jun 30, 2016 at 10:07 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 30, 2016 at 12:26 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 30, 2016 at 12:26 PM
Related:
- Assign numerical value to cell based on text in another cell
- Conditional formatting if cell contains text - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel send value to another cell - Guide
- Excel: If Date =, then enter a value ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 30, 2016 at 12:26 PM
Jun 30, 2016 at 12:26 PM
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
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
