Equation: equals number if another number is between a certain range

njsutorius

New Member
Joined
Apr 6, 2014
Messages
43
I would like to have a grade scale so that where c3 = wherever b3 falls in the range in column A.

Thus if B3 is 10 then C3 would equal 4.5 on the scale range.

We can breakout the range in A if needed into multiple columns if necessary.

a
b
c
1
1-5 = 0
CPH
Score
3
6-8 = 3.5
10
4
9-11 = 4.5
5
12+ = 5
6
7

<tbody>
</tbody>


Thanks for any assistance.
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
A​
B​
C​
D​
E​
1​
CPH​
Score​
CPH​
Score​
2​
0​
0.0​
10​
4.5​
D2: =LOOKUP(C2, $A$2:$B$5)
3​
6​
3.5​
4​
9​
4.5​
5​
12​
5.0​
 

njsutorius

New Member
Joined
Apr 6, 2014
Messages
43
You win the prize of my thankfulness. You are a great resource to helping your fellow man. Thanks!
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
Wow, you're welcome.
 

njsutorius

New Member
Joined
Apr 6, 2014
Messages
43
Ya that vlookup is pretty much right up my ally on this question. I am going to read your article in detail as I think vlookup may be useful for some of my other ideas as well.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,036
Messages
5,466,153
Members
406,471
Latest member
tsou88

This Week's Hot Topics

Top