Forum Discussion
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...
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.
- Thank you for this, it totally checks out.
- You're welcome!
