PERCENTILE Function

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.

Ask the Community