In col if high is 83 and low 15 how do i get high =100 and low=0

[Sarah]

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 here: A4 = 35.

A201 = 83 MAX
A202 = 15 MIN

 

[Stephen]

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 here: 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))

 

[Sarah]

Thanks very much Stephen. That worked perfectly.

Sarah.