A formula is a statement written by the user to be calculated. Formulas range from very simple to highly complex. They can contain values, references to cells, defined names and functions. All formulas must start with the equals sign, e.g. “=2+6”
A function is a small program designed to calculate specific values. Many standard functions are built into Excel such as a function to sum values or calculate the current time. Additional functions can be defined using the Visual Basic programming language (which is outside the syllabus). Functions are typed alongside parenthesizes within which the arguments are listed.
E.g.=NOW() returns the current time
=SUM(3+5+7)*3 will multiply the sum of 3, 5 and 7 by 3.
No comments:
Post a Comment