Calc:函数和公式

出自OOo 中文手册翻译

跳转到: 导航, 搜索

这是OpenOffice.org 3.x Calc指南的第八章,英文版是由OOoAuthors group制作的。OpenOffice.org的Documentation有本文英文版的PDF版本。

中文版由OOo爱好者翻译制作。中文版本版权归所有翻译制作的参与者。

目录

[编辑] Formulas

Up to now, we have been entering one of two basic types of data into each cell that we have been using, Numbers and Text. However, it is not always the case that we will know what the contents should be. Often what should be there is dependent on the contents of other cells. This is handled by a third type of data known as the formula. Formulas are equations using numbers and variables to get a result. In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.

[编辑] Using functions

A function is a pre-defined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet. All you have to do is add the arguments, and the calculation is automatically made for you. This helps to facilitate the creation of the formulas needed to get the results that you are looking for.

[编辑] 目录 TOC

  • Using Formulas and Functions
  • Creating formulas
  • Using functions
  • Finding and fixing errors
  • Examples of functions
  • Using regular expressions in functions

[编辑] 相关链接

本文原文

个人工具