ExcelBanter - change cell value based on another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - change cell value based on another cell (https://www.excelbanter.com/excel-worksheet-functions/450669-change-cell-value-based-another-cell.html)

set99

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

Gord Dibben[_2_]

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

All times are GMT +1. The time now is 12:20 PM.