Here are some problems that our users have asked and received explanations on
how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22
Our goal is to be able to show the percentile rank of the 10 companies for their mean.
Solved by X. W. in 27 mins
I need a formula that ranks the highest number in the 1st percentile and the lowest number at the 100th percentile.
Solved by T. D. in 25 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins
My rank formula in excel is not working =IFERROR(RANK(C4,C24:H24,0),"") please help
Solved by K. J. in 20 mins
sir, how to find age calculator age on date formula