Timeline for 5+5% Equals 505% In Excel, Can Someone Explain The Maths Here?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 17, 2021 at 2:41 | comment | added | Rajesh Sinha | Nice one you get +10 ☺ | |
| Jul 17, 2021 at 0:21 | comment | added | BradR | 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% | |
| Jul 16, 2021 at 7:48 | history | edited | StarCat | CC BY-SA 4.0 |
added 304 characters in body
|
| Jul 16, 2021 at 7:45 | comment | added | Reddy Lutonadio | @MikeScott Understood. | |
| Jul 16, 2021 at 7:32 | comment | added | Mike Scott | @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, 2021 at 7:26 | vote | accept | Matte | ||
| Jul 16, 2021 at 7:24 | history | answered | StarCat | CC BY-SA 4.0 |