Google Sheets Formula Directory
Explore our comprehensive library of Google Sheets formulas with examples, use cases, and our interactive formula generator.
Showing 4 formulas in Statistical
MEDIAN
=MEDIAN(A1:A5)Returns the median (middle value) of a range of numbers in Google Sheets, useful for central tendency.
View formula detailsMODE
=MODE(A1:A5)Returns the most frequently occurring value in a range in Google Sheets, useful for identifying trends.
View formula detailsSTDEV
=STDEV(A1:A5)Calculates the sample standard deviation of a range in Google Sheets, measuring data spread.
View formula detailsVAR
=VAR(A1:A5)Calculates the sample variance of a range in Google Sheets, measuring data dispersion.
View formula detailsFormula Generator
Create custom formulas with our AI-powered tool
Can't find the formula you need?
Use our AI-powered Formula Generator to create custom Google Sheets formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Transform Your Spreadsheet Experience
Join thousands of users revolutionizing their data workflows. Get access to premium tools and expert knowledge.