Press Esc to close
**11-27-2014** | Response Time: 3 days

How to Choose Your

Excel Expert Type...

Select the field of expertise that best matches your question so we can assign the appropriate expert to handle your question. If you donâ€™t know - select 'General Expert'.

Why open an account with

Excel-Formulas.com?

Excel-Formulas.com?

- Get access to our Excel experts
- One central location for all your questions and answers
- And of course, so you can get your answer!

E-Mail address: |

First visit |

Already registered |

**Question:**

**I want to take a column that has cost (column I) and out beside that column have a column that shows the end price. My mark up is cost +12% or a 10.71% margin. When I do the formula I think for this (=I2*1.1071) the total doesn't come out right. The cost is $52.50 and the end price should be $58.80, but instead it's showing $58.12. What am I doing wrong?**

**Answer:**

**The answer is quite simple, you need to multiply by your markup not your margin.**

**Multiply 52.5 by 112% and you'll get 58.8, like this:**

`=I2*112%`

**TIP: in Excel you can use percent in formulas, like I did in the formula above.**

Tags: Math

Enter your email and get everything you need to know about Excel Formulas!

- 54 Training Videos
- 90-Second Formula Exercises
- Detailed Exercise Solutions
- And more