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