View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default 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