cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PKOG12 Visitor
Visitor

How do I do this; If results in Column A is in top 20%, return 1, if it is top 40%, return 2......

I am trying to use the IF and ELse to create a new column to normalise my data using percentiles. The aim is to allocate a number to the top 20%, 40%, 60%....