We want to find out the personnel who are in top 20% (indicated by Tops!) and lowest 5% salary range (to be indicated by "Lows", otherwise Middle in the column under Top/Low). (Use IF function). VBA does not understand Excel function Percentile. So you should calculate the two percentiles, and then use those numbers in VBA If function.

i have this so far l

=IF(F8=0.2,"Tops",IF(F8>=0.05*F8,"Lows","Middle"))............... it only gives me "Lows"