Formula and function

[MyExcel]

hi
i want to ask about the difference between Formula and function

 

[Peter_SSs]

hi
i want to ask about the difference between Formula and function

For example:
=INT(A1)+SQRT(A1)+LEN(A1)

The above formula uses three functions:
INT, SQRT and LEN

 

[Colin Legg]

Hi,

Here are the definitions from the helpfile:

Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result.
=5+2*3



A formula can also contain any or all of the following:

functions: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.

references:

operators: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.

constants: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.