1

Here's the screenshot of formulae and the values:

MS Excel

5
  • 3
    5 + 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.
    – StarCat
    Jul 16 at 7:12
  • @StarCat You should include your comment as an answer. Jul 16 at 7:20
  • @ReddyLutonadio, done.
    – StarCat
    Jul 16 at 7:26
  • So do you need to calculate 5 * (1+5%) instead, which equals 5.25?
    – AdamV
    Jul 16 at 12:50
  • This is a mathematical problem, 5+0.05=5.05...
    – Lee
    Jul 19 at 7:29
5

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).
4
  • 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.
    – Mike Scott
    Jul 16 at 7:32
  • @MikeScott Understood. Jul 16 at 7:45
  • 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%
    – BradR
    Jul 17 at 0:21
  • Nice one you get +10 ☺ Jul 17 at 2:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.