Forum Discussion
Terry-Martins
Dec 22, 2022Copper Contributor
Excel Formula Help
Hi @everyone, I would please like some with a formula. I'm taking an online course on Excel and was presented with a practice challenge, I couldn't quite figure out how to answer the question so I lo...
Patrick2788
Dec 22, 2022Silver Contributor
I believe the +1 is there so you arrive at the correct price.
For example, let's say the price is $100. The 'markup rate' is 25%. If you multiply 100*25% you get $25. However, if you multiply 100*1.25 you arrive at the correct price after the markup has been applied: $125.
For example, let's say the price is $100. The 'markup rate' is 25%. If you multiply 100*25% you get $25. However, if you multiply 100*1.25 you arrive at the correct price after the markup has been applied: $125.
- Terry-MartinsDec 22, 2022Copper ContributorThank you for this, it totally checks out.
- Patrick2788Dec 22, 2022Silver ContributorYou're welcome!