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
|