| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign values to a cell based on values in another cell?
I'm trying to figure out a way to automaticcaly assign values to a cell (B3)
based on values typed on cell A3. Example: A3 values (typed) = 10%, 30%, 50%, 70%, 100% B3 values (automatically assigned) = min, low, medium, high, max Tks for the help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to assign values to a cell based on values in another cell?
=LOOKUP(A3,{0.1,0.3,0.5,0.7,1},{"min","low","mediu m","high","max"})
Will you have values that aren't exactly 10, 30, 50, 70 or 100? If so, how do you want to deal with them? Gord Dibben MS Excel MVP On Wed, 5 Dec 2007 11:44:00 -0800, Joao Lopes <Joao wrote: I'm trying to figure out a way to automaticcaly assign values to a cell (B3) based on values typed on cell A3. Example: A3 values (typed) = 10%, 30%, 50%, 70%, 100% B3 values (automatically assigned) = min, low, medium, high, max Tks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Assign values to text within a cell | Excel Worksheet Functions | |||
Hybrid Mode
