OpenOffice Calc Formulas

OpenOffice.org Calc is a free spreadsheet program that allows users to perform complex calculations on entered data as well as create and represent various formulas to produce certain results. Take a look at the below steps to carry out simple calculations adding up a whole column of cells:

  • Type in some numbers in cells A1 to A9
  • Confirm with `Enter', and the cursor will move to cell A10
  • Type (without quotes) "=sum(A1:A9)"
  • Confirm with `Enter', and you will view see the result of the addition displayed in cell A10, and the formula will be visible in the Calculation bar.

Programs that may interest you

Useful info on "OpenOffice Calc Formulas"

Useful OpenOffice Calc Formulas and Related Tricks

Hi All, I am working on Openoffice.org - Calc. Can anybody help me to covert amount in numbers into Words for example : Rupees 4,00,00,000.50 to Rupees Four crores

OpenOffice Calc Formula - OpenOffice Calc Formula …

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

OpenOffice.org 3.x Calc Guide - Apache …

Using Spreadsheets in OpenOffice.org This PDF is designed to be ... http://extensions.services.openoffice.org/ and ... to plot B3:B11 against G3:G11, …

Creating formulas - Apache OpenOffice Wiki

Creating formulas. You can enter formulas in two ways, either directly into the cell itself, or at the input line. Either way, you need to start a formula with one of ...

Answers about "OpenOffice Calc Formulas"