need to calculate the cost of the item sold at $420 with a mark-up of 2.5% in excel 2007. What formula to use? Can Data What-if-Analysis function able to do this?

By: Yazid

By: Yazid

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

I have assumed you want to know what the cost is before 2.5% is applied? If so use the following formula…

`=A1/(100+2.5)*(100)`

I have based the formula upon a monetary value in cell A1 (your $420).