Documentation/AOO4 User Guides/Calc Guide/Formulas And Functions/Examples of Functions

Apache OpenOffice 4.1 Calc Guide

Chapter 7: Formulas and Functions

< Previous Section

Next Section >

• Introduction
• Setting Up a Spreadsheet
  • The Trap of Fixed Values
  • Lack of Documentation
  • Error-checking Formulas
  • Appearance vs. Computation
• Creating Formulas
  • Operators in Formulas
  • Operator Types
    • Arithmetic Operators
    • Comparative Operators
    • Text Operators
    • Reference Operators
      • Range Operator
      • Reference Concatenation Operator
      • Intersection Operator
  • Relative and Absolute References
    • Relative Referencing
    • Absolute Referencing
  • Order of Calculation
  • Calculations Linking Sheets
• Understanding Functions
  • Understanding the Structure of Functions
  • Nested Functions
  • Function Wizard
  • Entering Formulas in Cells or the Input Line
• Strategies for Creating Formulas and Functions
  • Place a Unique Formula in Each Cell
  • Break Formulas into Parts and Combine the Parts
  • Use the Basic Editor to Create Functions
• Finding and Fixing Errors
  • Error Messages
    • Examples of Common Errors
    • Err:532 #DIV/0!
    • #VALUE Non-existent Value and #REF! Incorrect References
  • Color Coding for Input
  • The Detective
• Examples of Functions
  • Basic Arithmetic and Statistic Functions
    • Basic Arithmetic
    • Simple Statistics
  • Rounding off Numbers
    • Rounding Methods
• Using Regular Expressions in Functions
• Advanced Functions

< Previous Page

Next Page >

Examples of Functions

For novices, functions are among the most intimidating features of OpenOffice's Calc. New users quickly learn that functions are an important feature of spreadsheets, but there are almost four hundred, and many require input that assumes specialized knowledge. Fortunately, Calc includes dozens of functions that anyone can use.