Spreadsheet Built-In Functions; Argument Rules - Brother GeoBook NB-80C Instructions Manual

. Appendix: '
, •
Spreadsheet Built-in Functions
Spreadsheet uses
floating point math,
which has benefits such
as speed But floating
point math produces
errors in the 17th or 18th
significant o_git. While
this is often not
detectable, the errors
become apparent in
some calculations,
especially when you use
financial functions like
IRR and NPV.
Spreadsheet adheres to
the IEEE 754 standards
for floating point
calculations.
Bui/t-kzfunaions are prewritten formulas that take a value, perform a
mathematical operation, and _turn a result. For example, you can use a
built-in function to total a grotlp of fiumbers.
You can also use built-in functions to insert information in Spreadsheet; for
example, use the Time & Date functions to insert the current date and time.
Functions are represented by a keyword followed by arguments enclosed in
parentheses. The function returns a value based on the arguments you enter.
For example, in the expression SQRT(144), SQRT is the keyword for the
square root function, and 144 is the argument. This function returns 12, the
square root of 144. ',
Argument Rules
The following rules apply to using arguments in functions:
• You can use numbers, cell addresses, or cell ranges in Spreadsheet as
values.
t
You must enclose text string arguments in quotation marks.
You must specify interest rates as decimal values, and they must
correspond to the same time unit as the term. For example, payments
that are monthly require a monthly interest rate.
You must express trigonometric angle arguments in radians. If you
want to convert degrees to radians, use the RADIANS0 function.
Some trigonometric functions return radians. If you need the returned
value expressed in degrees, use the DEGREES 0 function.
Appendix 215