Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Mathematical
POWER
=POWER(2, 3)Raising a number to a specified power for exponential calculations
View formula detailsPRODUCT
=PRODUCT(A1:A3)Multiplying a range of numbers for aggregate calculations
View formula detailsSQRT
=SQRT(16)Calculating the square root of a number for geometric or statistical analysis
View formula detailsSUM
=SUM(A1:A5)Adding up a range of numbers for totals
View formula detailsAVERAGE
=AVERAGE(A1:A5)Finding the mean of a range of numbers for statistical analysis
View formula detailsCOUNT
=COUNT(A1:A5)Counting numeric cells in a range for data tallying
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom 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
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.