How to Divide in OpenOffice Calc

Save

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
Promoted By Zergnet

Comments

You May Also Like

  • 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...

  • 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...

  • 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...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!