"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))