OpenOffice.org, an open-source alternative to Microsoft Office, doesn't have every function and option of its for-pay counterpart, but it has all the basics, including all standard calculator functions. OpenOffice Calc performs basic arithmetic functions using standard symbols: "+" for addition, "-" for subtraction, "*" for multiplication and "/" for division. Like Excel, OpenOffice Calc requires an equals sign to signify a formula; without it, typing "20/5" causes "20/5" to display in a cell, not "4."
Type "=" followed by a number, a slash -- "/" -- and then another number, the divisor. Press "Enter" to calculate. The formula "=50/5" yields "10."
Include a division function in another arithmetic function, but keep in mind that Calc uses the standard order of operations, parentheses, exponent, multiply, divide, add, subtract (PEMDAS). If you type "=100+100/10" Calc performs the division first: 100 divided by 10 equals 10. Add 100 to that and get the result "110." "=(100+100)/10" gives you "20"; 100 plus 100 equals 200, divided by 10 equals 20.
Substitute cell values for numbers in the division equation. Instead of "=50/5" type "=A1/B1" to divide the value in cell A1 by the value in cell B1. The values must be numbers or the formula will result in a "#VALUE!" error.
- Photo Credit Hemera Technologies/AbleStock.com/Getty Images
How to Divide One Cell by Another
Spreadsheets, such as Microsoft's Excel and OpenOffice's Calc, allow you to perform complex calculations by referencing information in grid-like cells. Cells are...
How to Create Formulas in Spreadsheets
Creating a formula in a spreadsheet is similar to creating one on paper. You can add, subtract, multiply, divide or find an...
Cubicles Vs. Open Office Space
Whether cubicles or open office space is better for employee productivity is an ever-changing debate. A glimpse at the pros and cons...