| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In col if high is 83 and low 15 how do i get high =100 and low=0
In a column if highest number is 83 and lowest is 15. What formula should I
use to get high =100 and low=0. Eg what should be the formula used he A4 = 35. A201 = 83 MAX A202 = 15 MIN |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In col if high is 83 and low 15 how do i get high =100 and low=0
"Sarah" wrote in message
... In a column if highest number is 83 and lowest is 15. What formula should I use to get high =100 and low=0. Eg what should be the formula used he A4 = 35. A201 = 83 MAX A202 = 15 MIN In principle, you would need to calculate (A4-min)*100/(max-min) Assuming there is nothing in column A except your numbers, you could do the whole job with this formula: =(A4-MIN(A:A))*100/(MAX(A:A)-MIN(A:A)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In col if high is 83 and low 15 how do i get high =100 and low
Thanks very much Stephen. That worked perfectly.
Sarah. "Stephen" wrote: "Sarah" wrote in message ... In a column if highest number is 83 and lowest is 15. What formula should I use to get high =100 and low=0. Eg what should be the formula used he A4 = 35. A201 = 83 MAX A202 = 15 MIN In principle, you would need to calculate (A4-min)*100/(max-min) Assuming there is nothing in column A except your numbers, you could do the whole job with this formula: =(A4-MIN(A:A))*100/(MAX(A:A)-MIN(A:A)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| High = 4 | Excel Worksheet Functions | |||
| High = 4 take 2 | Excel Worksheet Functions | |||
| Formula for High Value | Excel Worksheet Functions | |||
| high-low lines | Charts and Charting in Excel | |||
| High bars | Charts and Charting in Excel | |||
Linear Mode
