Here's the screenshot of formulae and the values:
-
35 + 5% = 5 + 0.05 = 5.05. Shown in an Excel cell formatted as a “percentage” this gets displayed as 505%. One percent = 0.01 so 5 equals 500%. Tip: please put any images directly in you question, not as an external link.– StarCatCommented Jul 16, 2021 at 7:12
-
@StarCat You should include your comment as an answer.– Reddy LutonadioCommented Jul 16, 2021 at 7:20
-
@ReddyLutonadio, done.– StarCatCommented Jul 16, 2021 at 7:26
-
So do you need to calculate 5 * (1+5%) instead, which equals 5.25?– AdamVCommented Jul 16, 2021 at 12:50
-
This is a mathematical problem, 5+0.05=5.05...– LeeCommented Jul 19, 2021 at 7:29
Add a comment
|
1 Answer
This has a simple explanation:
One percent = 0.01 so 5 equals 500%.
5 + 5% = 5 + 0.05 = 5.05
Shown in an Excel cell formatted as a “percentage” this gets displayed as 505%.
Maybe an even simpler way to think about it is this:
- Whenever you place a “%” sign after a number, Excel will treat it like it’s divided by 100.
- When a cell is formatted to display a percentage, Excel will will display the value in the cell multiplied by 100 (and followed by a “%” sign).
-
2@ReddyLutonadio It’s not really about how Excel handles percentages — it couldn’t reasonably handle them any other way. 5% is just a different way of writing 0.05. Commented Jul 16, 2021 at 7:32
-
-
Another non Excel way of looking at it 5% is 5 out of 100 or mathematically 5/100 or .05. So adding this to 5 gives you 5.05. If you multiple this times 100% you get 505%– BradRCommented Jul 17, 2021 at 0:21
-