asked 2020-12-20 00:21:07 +0200

طارق سلطان gravatar image

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

edit retag flag offensive close merge delete



Simple arithmetic? 250 x 1.05 = 262.5

robleyd gravatar imagerobleyd ( 2020-12-20 01:24:56 +0200 )edit

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

Lupp gravatar imageLupp ( 2020-12-20 02:54:34 +0200 )edit

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

newbie-02 gravatar imagenewbie-02 ( 2020-12-20 02:57:00 +0200 )edit

I'm considering if your math teacher would be interested in my answer posted to this question:

Lupp gravatar imageLupp ( 2020-12-20 03:06:25 +0200 )edit

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.

ve3oat gravatar imageve3oat ( 2020-12-20 15:57:57 +0200 )edit

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)

Lupp gravatar imageLupp ( 2020-12-20 16:35:31 +0200 )edit