| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
change cell value based on another cell
I am looking for a way to have a cell change its value based on different range of values in another cell
Example: G6 between 0-10000 H6=4 G6 between 10000-25000 h6=5 G6 between 25000-35000 H6=6 G6 between 35000-60000 H6=7 G6 between 60000-100000 H6=9 any help would be great |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change cell value based on another cell
You have your ranges overlapping but try this to get you started.
In H6 enter this formula. =LOOKUP(G6,{0,10000,25000,35000,60000},{4,5,6,7,9} ) Gord On Tue, 17 Feb 2015 23:38:39 +0000, set99 wrote: I am looking for a way to have a cell change its value based on different range of values in another cell Example: G6 between 0-10000 H6=4 G6 between 10000-25000 h6=5 G6 between 25000-35000 H6=6 G6 between 35000-60000 H6=7 G6 between 60000-100000 H6=9 any help would be great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change background color of cell based on vlookup in cell | Excel Discussion (Misc queries) | |||
| Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
Linear Mode
