7. Differences between formulae and functions

FORMULA
FUNCTION
A formula is typed directly into the formula bar A function is built into the software.; it is a special type of formula
Unable to nest a formula Can nest functions
Formula are simple calculations Functions are used to simplify complicated maths
Formulas do not have built-in wizards A function often has a built-in wizard to help you complete them e.g. VLOOKUP

 

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Formula and Functions