Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

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
    Commented Jul 16, 2021 at 7:32
  • @MikeScott Understood. Commented Jul 16, 2021 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
    Commented Jul 17, 2021 at 0:21
  • Nice one you get +10 ☺ Commented Jul 17, 2021 at 2:41