|
1. Position the pointer over a cell.
2. Press the left mouse button or press F2 to start the cell editing mode.
3. Begin the entry with an equal sign (=) and then the name of the formula followed by parameter values between parentheses.
NOTES:
· A formula can contain numbers, operators, worksheet functions, cell references and defined names.
· Numbers in formulas can be followed by a percentage sign (%). Numbers with trailing percent signs are treated as percentages (e.g. 135% is evaluated as 1.35).
· If text is encountered when a number is expected, the text is converted to a number when possible. If a number is encountered when text is expected, the number is converted to text. If the conversion is unsuccessful, #VALUE is returned.
· The value TRUE always convert to 1, FALSE converts to zero. If a number is encountered when a logical value is expected, a zero is converted to FALSE. All other number different to zero will be converted to TRUE. All other text returns #VALUE!.
· Dates and time values are recognized and converted to their serial values before calculation.
Related topics:
Formula Operators Table
Operator Precedence Table
Worksheet functions
|