Hi, I’m after a hand at sorting out some functions in excel.
I want a column to display a value based on another number. For example, in C3:C12 I have varying numbers from 50 – 120, I want B3:B12 to give each opposite number a value based on the range they fall in. So anything over 105 I want given a value of 1, anything below 105 but over 90 I want given a value of 2, below 90 but over 80 a value of 3 and so on.
I’ve tried different functions in the function wizard and can’t get past one value before it errors out. Appreciate any help, thankyou.
