Percent In Range

nutritiouspig

Well-known Member
Joined
Jan 8, 2003
Messages
615
Setup:

Floor = 30k (in this example... actually cell based)
Ceiling = 50k (in this example... actually cell based)

If I had a value of 40k, I want a formula that tells me the value is 50% within that range. Where 30k would be 0% and 50k would be 100%.

How do I do this?

Floor is in AE3
Ceiling is in AF3

Variable value (40k) is in O3

Thanks!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Code:
=(O3-AE3)/(AF3-AE3)

..You may want to use data-->validation to limit O3 to be between AE3 and AF3.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,020
Messages
5,569,664
Members
412,286
Latest member
kychemist00
Top