Basic Functions in Excel
Functions are predefined formulas in Microsoft Excel that perform calculations automatically. Functions help users save time, reduce errors, and analyze data efficiently.
Understanding Function Syntax
Every function follows a standard structure called Syntax.
=FUNCTION_NAME(argument1, argument2, argument3)
| Part | Description |
|---|---|
| = | Starts a function. |
| Function Name | The predefined Excel function. |
| Arguments | Values, cell references, or ranges used by the function. |
SUM Function
The SUM function adds numbers together and returns the total.
Syntax
=SUM(number1,[number2],...)
Arguments
| Argument | Description |
|---|---|
| number1 | Required. First number or range. |
| number2 | Optional. Additional numbers or ranges. |
Example
=SUM(10,20,30)
Result: 60
AVERAGE Function
The AVERAGE function calculates the arithmetic mean of selected numbers.
Syntax
=AVERAGE(number1,[number2],...)
Arguments
| Argument | Description |
|---|---|
| number1 | First value or range. |
| number2 | Additional values. |
Example
=AVERAGE(50,60,70)
Result: 60
ROUND Function
The ROUND function rounds a number to a specified number of digits.
Syntax
=ROUND(number,num_digits)
Arguments
| Argument | Description |
|---|---|
| number | The value to round. |
| num_digits | Specifies the number of digits to keep. |
num_digits Values
| Value | Meaning | Example |
|---|---|---|
| Positive | Rounds decimal places. | =ROUND(45.678,2) |
| 0 | Rounds to nearest whole number. | =ROUND(45.678,0) |
| Negative | Rounds left of decimal. | =ROUND(4567,-2) |
COUNT Function
Counts only cells containing numeric values.
Syntax
=COUNT(value1,[value2],...)
Example: =COUNT(A1:A10)
COUNTA Function
Counts all non-empty cells including text, numbers, dates, and formulas.
Syntax
=COUNTA(value1,[value2],...)
Example: =COUNTA(A1:A10)
COUNTBLANK Function
Counts the number of empty cells in a range.
Syntax
=COUNTBLANK(range)
Example: =COUNTBLANK(A1:A10)
MIN Function
Returns the smallest value from a range.
Syntax
=MIN(number1,[number2],...)
Example: =MIN(45,67,89,22)
Result: 22
MAX Function
Returns the largest value from a range.
Syntax
=MAX(number1,[number2],...)
Example: =MAX(45,67,89,22)
Result: 89
DATE Function
Creates a valid Excel date using Year, Month, and Day values.
Syntax
=DATE(year,month,day)
| Argument | Description |
|---|---|
| year | Year value. |
| month | Month number (1-12). |
| day | Day number. |
Example: =DATE(2026,6,4)
TODAY Function
Returns the current system date.
Syntax
=TODAY()
NOW Function
Returns the current system date and time.
Syntax
=NOW()