Functions and Formulas

As said in the previous blog, data can be entered in text, numbers, and even formulas. Now, we are going to tackle on Functions and Formulas

Pythagorean Theorem

A formula is an expression  used to perform calculations,begins with an equal sign, composed of operands
and operators, and may contain constants, cell references, ranges and grouping symbols.

An example of a Formula is:

• 150*0.5

A function, on the other hand, is a predefined formula, may require arguments as inputs, returns a value, and may be used together with other functions and other operations.

An example is:

• AVERAGE(A1:A10)