ExcelBanter - Percentrank function display

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Percentrank function display (https://www.excelbanter.com/excel-worksheet-functions/161926-percentrank-function-display.html)

Michael Gudyka

Percentrank function display

Is it possible to change the result of the function so it doesn't say ...th
all of the time? The 73th percentile (rather then 73rd) just sounds a little
bit illiterate. Thanks in advance.
--
Michael Gudyka
St. Charles, IL

JW[_2_]

Percentrank function display

What is your formula? When I use PercentRank, I get back a decimal
value.
Michael Gudyka wrote:
Is it possible to change the result of the function so it doesn't say ...th
all of the time? The 73th percentile (rather then 73rd) just sounds a little
bit illiterate. Thanks in advance.
--
Michael Gudyka
St. Charles, IL

Michael Gudyka

Percentrank function display

JW:

I'm just using the Function Wizard. Do you think it's a formatting issue?
--
Michael Gudyka
St. Charles, IL

"JW" wrote:

What is your formula? When I use PercentRank, I get back a decimal
value.
Michael Gudyka wrote:
Is it possible to change the result of the function so it doesn't say ...th
all of the time? The 73th percentile (rather then 73rd) just sounds a little
bit illiterate. Thanks in advance.
--
Michael Gudyka
St. Charles, IL

All times are GMT +1. The time now is 05:41 AM.