MS Excel helps you perform calculations quickly and accurately using built-in formulas. By learning basic Excel formulas, you can easily add numbers, find averages, identify maximum and minimum values, and analyze data efficiently in everyday tasks.
Foundational Excel Formulas
1. Sum Function
The SUM function adds all numeric values in a selected range. It’s commonly used to calculate totals.
Syntax: =SUM(number1, [number2], ...)
Where:
number1, [number2], are the numbers, cell references (e.g., C3:C8), or ranges to add together. Use this to calculate the total of values, like summing vegetable costs in C3:C8
2. Max Function
The MAX function returns the highest value from a range, helping identify peak expenses.
Syntax: =MAX(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C12) to evaluate. Apply this to find the highest value, such as the most expensive item in a list.
3. Min Function
The MIN function finds the lowest value in a range, useful for spotting minimum costs.
Syntax: =MIN(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C10) to evaluate. Use this to determine the lowest value, like the cheapest vegetable.
4. Average Function
The AVERAGE function calculates the mean of a range of values, giving insight into typical spending.
Syntax: =AVERAGE(number1, [number2], ...)
Where:
number1, [number2],are the numbers or range (e.g., C5:C10) to average. Employ this to find the mean value, such as the average cost of items.
5. Count Function
The COUNT function counts how many cells in a range contain numeric values.
Syntax: =COUNT(number1, [number2], ...)
Where:
number1, [number2], are the numbers or range (e.g., C5:C10) to count.
6. Len Function
The LEN function returns the number of characters in a text string. It’s useful for data validation and text analysis.
Syntax: =LEN(text)
Where:
Text is a cell reference (e.g., A5) containing the text string to measure. Apply this to count characters, like the length of "brinjal".
7. SUMIF Function
The SUMIF function adds values that meet a specific condition.
Syntax: =SUMIF(range, criteria, [sum_range])
Where:
Range is the cells to check (e.g., C5:C10), criteria is the condition (e.g., ">20"), and [sum_range] (optional) is the cells to sum if different from range. Use this to add values meeting a condition, like costs over 20.
8. AVERAGEIF Function
The AVERAGEIF function calculates the average of values that satisfy a condition.
Syntax: =AVERAGEIF(range, criteria, [average_range])
Where:
Range is the cells to check (e.g., C5:C10), criteria is the condition (e.g., ">20"), and [average_range] (optional) is the cells to average if different from range. Apply this to average values meeting a condition, like costs above 20.
