← 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:
- In D2, type
=B2/C2. You’ll see something like 0.72. - Format it as a percentage:
- Google Sheets: press Ctrl + Shift + 5.
- LibreOffice Calc: Format, Cells, Numbers, Percent.
- 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
- Keyboard shortcuts for Google Sheets, Google Docs Editors Help.
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.
