|
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
|
No comments:
Post a Comment