Formula for giving point to particular no.
Do you mean that if A1 contains 76, the formula should return 1, if A2
contains 71, the formula should return 2, etc.?
Stefi
€˛kashish€¯ ezt Ć*rta:
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
|