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.– StarCatJul 16 at 7:12

@StarCat You should include your comment as an answer.– Reddy LutonadioJul 16 at 7:20

@ReddyLutonadio, done.– StarCatJul 16 at 7:26

So do you need to calculate 5 * (1+5%) instead, which equals 5.25?– AdamVJul 16 at 12:50

This is a mathematical problem, 5+0.05=5.05...– LeeJul 19 at 7:29
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. Jul 16 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%– BradRJul 17 at 0:21
