Formulas and 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 >

This is Chapter 7 of the Apache OpenOffice 4.1 Calc Guide.

A PDF of this chapter is available from this wiki page.