Skip to content

← Using a Computer, in Practice

Spreadsheets · 61 of 111

Show a percentage, without multiplying by 100

Expert guidance

Do this

With a mark in B2, and full marks in C2:

  1. In D2, type =B2/C2. You’ll see something like 0.72.
  2. Format it as a percentage:
    • Google Sheets: press Ctrl + Shift + 5.
    • LibreOffice Calc: Format, Cells, Numbers, Percent.
  3. It now shows 72%.

Why this way

The value stays 0.72 inside, so further sums still work. If you multiply by 100 and then add the percent format too, you’ll get 7200%. Expert guidance.

Do it today

Work out your percentage in three subjects. Three minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do