Читайте также:
|
September 15th, 2005
There are many mathematical and statistical constants in use that are needed in spreadsheets. For OpenOffice Calc, only PI has been hardwired as a function call - PI()
Using defined names is a quick and easy way to define constants in your spreadsheet that will also make your formulae more legible and maintainable. There will also be no need to have hidden sheets where the constants are defined. In this example, we will define Euler’s constant - e
Open the Define Names dialog as shown below.
Instead of assigning/associating the name with a particular cell, assign a fixed value as shown below. Exit the dialog
The named constant can now be used in formulae as shown below. Note that Names defined in this way do not appear in the name box - which is just above the cells area on the left.
Posted in Using OpenOffice Calc | 1 Comment»
Дата добавления: 2015-08-03; просмотров: 44 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Secret StarWars games | | | Listing Cell Notes |