Returns the value of a given percentile in a range
Sample Usage
PERCENTILE(Data:Data, .75)
Syntax
PERCENTILE(
-
range
-
percentile
- range—The group of cells to evaluate
- percentile—A decimal number between 0 and 1 representing the percentile to return
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.