Calculation of cost of item sold at a mark-up in Excel 2007

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

One thought on “Calculation of cost of item sold at a mark-up in Excel 2007

  1. Andrew

    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).

Leave a Reply

Your email address will not be published. Required fields are marked *