cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

#N/B with =PERCENT.RANG

MelissaLoen
Copper Contributor

‎Apr 22 2021 08:36 AM

‎Apr 22 2021 08:36 AM

#N/B with =PERCENT.RANG

Hello, 

 

Everytime I want to use =percent.rang with excel it dont work. I select the things (except the thing were there need to get the rang 

Labels:
419 Views
0 Likes
1 Reply
Reply
1 Reply
NikolinoDE

‎Apr 22 2021 09:17 AM

‎Apr 22 2021 09:17 AM

Re: #N/B with =PERCENT.RANG

@MelissaLoen 

 

PERCENTRANK function

  • If array is empty, PERCENTRANK returns the #NUM! error value.

  • If significance < 1, PERCENTRANK returns the #NUM! error value.

  • If x does not match one of the values in array, PERCENTRANK interpolates to return the correct percentage rank.

See examples in the link in the headline.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

0 Likes
Reply