Examples of Excel Basics Formulas
1. Basic Arithmetic
Add two numbers:
=A1 + A2
If A1 = 5 and A2 = 10, this formula will return 15.
Multiply two numbers:
=B1 * C1
Subtraction two numbers:
=A1 - A2
2. Built-in Functions
o SUM: Add a range of numbers.
=SUM(A1:A5)
This adds the values in cells A1 through A5.
AVERAGE:
o Calculates the average of a range.
=AVERAGE(B1:B10)
IF:
o Performs logical tests.
=IF(A1>10, "Pass", "Fail")
If the value in A1 is greater than 10, the result is "Pass"; otherwise, it's "Fail".
3. CONCATENATE / CONCAT
Joins multiple text strings into one (in newer Excel versions, use CONCAT).
Formula:
=CONCATENATE(A1, " ", B1)
or
=CONCAT(A1, " ", B1)
Example: Combines the values of A1 and B1 with a space in between.
or
4. Text Manipulation
Combine (concatenate) text:
=A1 & " " & B1
If A1 = John and B1 = Doe, the result is John Doe.
5. Lookup and Reference
VLOOKUP:
o Searches for a value in a table.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
6. HLOOKUP
Similar to VLOOKUP, but searches in rows instead of columns.
=HLOOKUP(50, A1:G3, 2, FALSE)
Example: Finds 50 in the first row and returns the value from the second row.
7. COUNT
Counts the number of numeric entries in a range.
=COUNT(A1:A10)
Example: Counts how many numeric values are in the range A1 through A10.
8. COUNTA
Counts all non-empty cells in a range (including text, numbers, and dates).
=COUNTA(A1:A10)
Example: Counts all non-blank cells in A1 through A10.
9. LEN
Returns the number of characters in a text string (including spaces).
=LEN(A1)
Example: Counts the characters in the text string in cell A1.
10. MAX
The MAX formula finds the highest (maximum) value in a range.
=MAX(range)
11. MIN
The MIN formula finds the lowest (minimum) value in a range.
=MIN(range)
