How to Calculate Percentage in Open Office

Written by riz khan
  • Share
  • Tweet
  • Share
  • Email

OpenOffice is an open-source application suite similar to Microsoft Office but that can be downloaded for free (http://www.openoffice.org/). It allows users to create and edit spreadsheets, documents, presentations, graphics and databases. The Calc application included in OpenOffice allows you to calculate percentages in much the same way Microsoft Excel does. If, for example, you want to calculate the percentage of male students in a classroom of 300 students, Calc can accomplish this task with a simple formula.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • OpenOffice software suite

Show MoreHide

Instructions

  1. 1

    Use the "Start" button to find and launch OpenOffice Calc on your computer. A new Calc worksheet will open.

  2. 2

    Click cell A1 to highlight it. Type "50," which is the number of boys in the class.

  3. 3

    Click cell B1 to highlight it. Type "300," which is the total number of students in the class.

  4. 4

    Click cell C1 of the worksheet. Type "=[A1]%[B2]" and hit the "Enter" key. The percentage of boys in the class will be displayed in cell C1.

Tips and warnings

  • When you enter the per cent formula, the answer will be given in decimals. To view the answer in percentage, highlight the answer cell by clicking it, right-click the highlighted cell and select the option "Format Cells." Select the "Number" tab in the "Format Cells" window. Check the "Percent" option in the "Category" list. The value will now be displayed in percentages, for instance 25 per cent.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.