Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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"
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started