View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default Backward Formula

I am trying to calculate a percentage based on a ranking system. For
example, #1 is the best. My problem:

1 out of 5 calculates to a percentage of 20%. I would like it to be a 100%
since 1 is the best.

Any help??