Using Notes with Formulas and Functions

One other method that can help you as you build functions and formulas for your spreadsheets is to place notations regarding the functions or formulas in notes. Supplying notes for a particularly complex function will help you sort out problems with that function, or it can also make it easier for the person who will enter the data into the spreadsheet.

To document a function or a formula with a note, click on the cell that contains the function. Select the Insert menu, and then select Note.

Type the information that you want to attach to the particular function in the Note box. Carefully documenting your work, especially as you work with unfamiliar functions, can help you make sure that your Calc spreadsheets ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.