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 other versions of Excel.

Also refer to the kalmstrom.com Blog post about Sales calculation in Excel.

Learn more

Office 365 from Scratch cover SharePoint Online from Scratch cover SharePoint Online Exercises cover
SharePoint Workflows from Scratch cover Excel 2016 from Scratch cover SharePoint Flows from Scratch cover

Always the latest news in the kalmstrom.com blog

Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

Products Buy FAQ Services Tips Services Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved