#Getting started
Excel Formulas: Your Powerful Tools For Calculation
Formula: A piece of code to perform a calculation. Formulas start with an equals sign (=) and contain functions, mathematical operators, values, and cell references.
Basic arithmetic Excel formulas are simple expressions that are mathematical operators to do the mathematical operations like addition, subtraction, multiplication, and division within your spreadsheet.
1. SUM: This function adds the total of a series of numbers.
2. AVERAGE: This function calculates the average of a series of numbers.
3. MEDIAN: This function returns the median average number of a series.
4. SUMPRODUCT: This function calculates the weighted average, which is very useful for financial analysis.
5. PRODUCT: This function multiplies all of a series of numbers.
6. MAX: This function returns the largest value in all cell ranges or values.
7. MIN: This function returns the smallest value in all cell ranges or values.
8. SUMIF: This function sums values in a range based on a specific condition.
9. Quotient: This function sums values in a range based on a specific condition.
10. MOD: This function returns the remainder of a division operation.
11. COUNT: This function counts the number of cells in a range.
