Thread: Percentage/PERCENTRANK
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Larry Holt
 
Posts: n/a
Default Percentage/PERCENTRANK
Ron Coderre wrote:
Dollar signs ($) in range references "lock in" that part of the reference.

Try this:
=C2/$C$1*100
Then copy that formula down

Does that help?

***********
Regards,
Ron

Excellent-thanks so much!
Reply With QuoteReply With Quote