Timeline for 5+5% Equals 505% In Excel, Can Someone Explain The Maths Here?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2021 at 7:29 | comment | added | Lee | This is a mathematical problem, 5+0.05=5.05... | |
| Jul 16, 2021 at 12:50 | comment | added | AdamV | So do you need to calculate 5 * (1+5%) instead, which equals 5.25? | |
| Jul 16, 2021 at 7:57 | history | edited | Máté Juhász | CC BY-SA 4.0 |
added 1 character in body; edited tags
|
| Jul 16, 2021 at 7:26 | vote | accept | Matte | ||
| Jul 16, 2021 at 7:26 | comment | added | StarCat | @ReddyLutonadio, done. | |
| Jul 16, 2021 at 7:24 | answer | added | StarCat | timeline score: 5 | |
| Jul 16, 2021 at 7:20 | comment | added | Reddy Lutonadio | @StarCat You should include your comment as an answer. | |
| Jul 16, 2021 at 7:12 | comment | added | StarCat | 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. | |
| Jul 16, 2021 at 7:04 | history | asked | Matte | CC BY-SA 4.0 |