View Single Post
  #1   Report Post  
set99 set99 is offline
Junior Member
 
Posts: 1
Default 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