Excel formulas - explained with real examples
17 guides. Every example is a request you can type into the Formula Studio, with the formula it gives.
Excel formula generatorBasics
- SUMSUM formula in Excel - add up cells, rows and columns
- AVERAGEAVERAGE formula in Excel - the mean of a range
- COUNT, COUNTA, COUNTBLANKCOUNT vs COUNTA vs COUNTBLANK - counting cells in Excel
- MAX, MINMAX and MIN in Excel - highest and lowest value
- ROUND, ROUNDUP, ROUNDDOWNROUND in Excel - decimals, nearest 100 or 1000
- Percentage formulasPercentage formulas in Excel - % of, % change, share of total
India & payroll
Conditions
- IFIF formula in Excel - with examples in plain words
- IF (nested), AND, ORNested IF and IF with AND / OR in Excel
- IFERRORIFERROR in Excel - hide #DIV/0!, #N/A and other errors
- SUMIF, SUMIFSSUMIF and SUMIFS in Excel - add up with conditions
- COUNTIF, COUNTIFSCOUNTIF in Excel - count cells that match (attendance P / A / L)