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 |