# percentage

How do I calculate the percentage in cells Example 250 + 5% = 262.5

First time here? Check out the FAQ!

We will be migrating from Ask to Discourse on the first week of August, read the details here

percentage

How do I calculate the percentage in cells Example 250 + 5% = 262.5

Asked: ** 2020-12-20 00:21:07 +0200 **

Seen: **42 times**

Last updated: **Dec 20 '20**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Simple arithmetic? 250 x 1.05 = 262.5

An explanation in addition to what @robleyd posted: You may read 1.05 as (100% + 5%).

"250 + 5%" Is gravely misleading. What you mean is "250 + 5%

of 250", and that's "105% of 250".Now 105% is simply applied as a factor of 1.05

for those not familiar with 5% == 0,05: '=250*(1+5%)' works too

(i'd hate my math teacher for not pointing this out, other pupil failed the test and turned away from math)

hello @Lupp ... sleepless? you posted while i was editing ...

I'm considering if your math teacher would be interested in my answer posted to this question: https://ask.libreoffice.org/en/questi...

From long experience with many software packages, I avoid using functions that include units (%, $, etc). My advice is to do the arithmetic from first principles, properly, and if you need to be reminded of the units (%, $, etc) then put them in text in the heading of the column. It makes life easier.

A remark: Listing the percent character together with designators for units is, at least, doubtable. I would even call it wrong.

You may see it as analogous to some old numerical measures like the dozen (sometimes abbreviated as

`dz`

), but there is the fundamental difference, that it -at least in a spreadsheet- actually changes the value dividing it by 100. If you enter 5 into a cell and format the cell to an US currency format, you may get shown 5.00$, but the value of the cell will still simply be 5. If you enter 5 again, and format the cell to "percentage", you will get 500%, and if you entered 5%, the value will be 0.05.This is different from the usage of units. The % sign is treated as a postfix operator.

??Of course spreadsheets respect the bad traditions of teaching about "percentages", and manage to top ...(more)