Most RecentNewestMost VotedMost ViewedHow 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%....
