Thread: Formula for giving point to particular no.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kashish kashish is offline
external usenet poster
  
Posts: 18
Default Formula for giving point to particular no.
I have random numbers in A column I want a formula for conditions given below

Percent Point
76-100 1
71-75 2
66-70 3
61-65 4
56-60 5
51-55 6
46-50 7
26-45 8
0-25 9

Reply With QuoteReply With Quote