PERCENTRANK

PERCENTRANK helps you calculate and analyze data by returning percentile rank results in AirSheet worksheets. It provides the tools you need to enter formulas quickly, follow syntax guidance, and work with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With PERCENTRANK, you can type the formula directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-worksheet references, build nested calculations, and get results that update automatically when source data changes. Whether you're troubleshooting formula errors, checking parameter format, correcting mismatched brackets or separators, or recalculating when referenced values are stored as text or involve circular references, PERCENTRANK helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53