Brother International PDP350CJ Owner's Manual - English - Page 189

When you enter a string as an argument to a function, you must enclose it in double quotation marks. If the text string itself contains quotation marks, use single quotation marks inside the string Ċ for example, Enter the word `vanilla' in the second blank." Strings can be up to 255 characters long (including quotation marks). If you want to specify a string with no characters, enter "" to specify empty text. Working with times and dates The time and date functions enable you to enter times and dates in serial See the Appendix for a list of time and date functions. form Ċ the form that Spreadsheet can understand. For example, you can use the DATEVALUE function to create the appropriate serialized date such as 33988 for January 20, 1993. These functions are most useful in formulas where the time and date are calculated rather than entered as a constant. Working with numbers See the Appendix for a list of financial, math, trigonometric, and statistical functions. You can use financial, math, trigonometric, and statistical functions. The result of these calculations is always a value that can be used in a math formula. Financial functions provide formulas for common financial calculations. For example, the FV (Future Value) function calculates the future value of a stream of regularly invested payments. The arguments for financial functions are either values or addresses of cells that contain values. When the argument is the interest rate, express it as its actual value (.07 rather than 7 to indicate 7%). Be certain to specify the same units for the term and the interest. If the interest is monthly, the term is also monthly. Mathematical functions provide common mathematical formulas. For example, INT (Integer) truncates a value to the nearest whole number. The arguments for mathematical functions are either values or addresses of cells that contain values. Trigonometric functions provide formulas for common trigonometric calculations. The arguments for trigonometric functions are either values or address of cells that contain values. Statistical functions provide formulas for common statistical calculations. For example, MAX returns the largest value in a list. The arguments for statistical functions consist of either values or address of cells that contain values. Using logical functions See the Appendix for a list of logical functions. A logical function says, If this is true then do that." For example, If the value in B12 is larger than 10,000 then display 50 in this cell." To create conditional statements, you use the IF function. The logical functions evaluate relationships and return true" or false" results. For example, the IF function looks at a condition such as whether the contents of B13 = 500 and returns a true or false condition. Spreadsheet 175