What is the difference between function and formula in Excel

What is the difference between function and formula in Excel

What are the Functions in Excel?

Function are those which is predefined for performing some financial, mathematical operation, logical such as sum(), max(), sum(), count(). you can also create your own

Function using the VB script. Now let us understand the Formulas in excel.

What is the Formula in Excel?

Formula are those which is generally created using mathematical operation by using basic mathematical symbols using Plus (+), Minus(-), Multiplication (*), Divide (/), exponential (^), usually in regular use we use the combination for function and formula to simplify our problem

A simple and easy example is average calculation 

What Does It Do?

This function calculates the average from a list of numbers. If the cell is blank or contains text, the cell will not be used in the average calculation. If the cell contains zero 0, the cell will be included in the average calculation.

Syntax =AVERAGE(Range1,Range2,Range3... through to Range30)

Note: To calculate the average of cells that contain text or blanks use =SUM() to get the total and then divide by the count of the entries using =COUNTA().