A formula is an expression that performs calculations on data in Excel. Functions are ready-made formulas that help us do calculations quickly and accurately.
=A1+B1
A formula is an expression used to perform calculations in Excel. It can use numbers, cell references, operators, and functions.
A function is a built-in formula in Excel. It helps perform common tasks like adding numbers, finding average, counting cells, and searching data.
Adds numbers together.
Example: =SUM(A1:A5)
Calculates the average of numbers.
Example: =AVERAGE(A1:A5)
Finds the smallest value in a range.
Example: =MIN(A1:A5)
Finds the largest value in a range.
Example: =MAX(A1:A5)
Counts the number of cells containing numeric values.
Example: =COUNT(A1:A5)
Returns the remainder after division.
Example: =MOD(10,3)
Returns a number raised to the power of another number.
Example: =POWER(2,3)
Counts the number of characters in text.
Example: =LEN("Excel")
Joins two or more text strings together.
Example: =CONCATENATE("Hello"," ","World")
Shows the current date and time.
Shows the current date only.
Searches vertically in a table and returns matching data from another column.
Searches horizontally in a table and returns matching data from another row.
Performs a logical test and gives different results based on the condition.
Example: =IF(A1>50,"Pass","Fail")
Counts cells that meet a specific condition.
Adds values that meet a specific condition.
Returns the rank of a number in a list of numbers.
Which function is used to add numbers?