1. Home
  2. Computing & Technology
  3. Spreadsheets

OpenOffice Calc Formulas Tutorial

By , About.com Guide

5 of 6

Mathematical Operators in OpenOffice Calc Formulas

The mathematical operator keys on the number pad are used to create Calc Formulas.

The mathematical operator keys on the number pad are used to create Calc Formulas.

© Ted French

Mathematical Operators

Creating formulas in OpenOffice Calc is not difficult. Just combine the cell references of your data with the correct mathematical operator.

The mathematical operators used in Calc formulas are similar to the ones used in math class.

  • Subtraction - minus sign ( - )
  • Addition - plus sign ( + )
  • Division - forward slash ( / )
  • Multiplication - asterisk (* )
  • Exponentiation - caret (^ )
Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Other Spreadsheets
  5. Open Office Calc
  6. Mathematical Operators - Using Mathematical Operators in OpenOffice Calc Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.