Excel Basic Formulas and Functions
Excel Basic Formulas and Functions
In this tutorial, you will learn basic Excel formulas and functions.
What is a Formula in Excel?
A formula is an expression used to calculate values in a cell. Excel Formulas always start with an equal sign (=).
Example:
= A1 + B1
| Function | Function Description | Example |
|---|---|---|
| SUM() | Adds all the numbers in a range of cells | =SUM(A1:A5) |
| AVERAGE() | Calculates the average (arithmetic mean) of values | =AVERAGE(B1:B5) |
| MAX() | Returns the largest number in a range | =MAX(C1:C5) |
| MIN() | Returns the smallest number in a range | =MIN(C1:C5) |
| COUNT() | Counts the number of numeric entries in a range | =COUNT(D1:D10) |
| COUNTA() | Counts the number of non-empty cells in a range | =COUNTA(E1:E10) |
| IF() | Returns one value if a condition is TRUE, and another if FALSE | =IF(A1>50, “Pass”, “Fail”) |
| NOW() | Returns the current date and time | =NOW() |
| TODAY() | Returns the current date | =TODAY() |
| LEN() | Returns the length of a text string | =LEN(A1) |
| CONCATENATE() | Joins two or more text strings | =CONCATENATE(A1, ” “, B1) |
