Home >Tips >Excel sales calculation kalmstrom.com site map icon Site map  

Use Formulas in Excel – Sales Calculation

An Excel tutorial by Peter Kalmstrom

Excel iconThe possibility to tell Excel to calculate is a crucial feature and the most important reason to use it. In two earlier demos Peter Kalmstrom has showed how to create Excel formulas for plus and minus and how to make Excel mulitpy and divide.

In the demo below Peter shows how to use these formulas in a more complicated calculation. As an example he uses a sales calculation where the input values are:
  • VAT, in percent

  • Margin, in percent

  • Product in-price

  • Number of sold items

  • Discounts

From this Peter calculates:
  • VAT, in dollars

  • Margin, in dollars

  • Product out-price

  • Price to customer

  • Total sales sum

Peter uses Excel 2013 for his demo, but the formulas are the same for earlier versions of Excel.