Home >Tips >Excel 2016 from Scratch >TRUNC and ROUND kalmstrom.com site map icon Site map  

Excel 2016 from Scratch Exercise

Modify Numbers – the TRUNC and ROUND functions

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconIn this exercise in the Excel 2016 from Scratch series, Peter Kalmstrom shows how to manipulate numbers with these functions:

  • TRUNC: shorten or truncate a number to a set number of decimals without rounding.

  • ROUND: round a number to a set number of decimals or to even tens.

Note that these functions really alter the data in your worksheet, so caclulations with shortened or rounded numbers will not be exact.

When you want exact calculations but still don't want to see many decimals, use the Excel formatting option that changes how many decimals are displayed without changing the numbers. Peter has used this formatting option in most of his earlier demonstrations.

Exercise

If you want to try the exercise yourself, please download the Excel file Peter uses in the demo!

Content

This is what Peter shows in the demo below:

  • How to name a cell to use it as an absolute reference.

  • How to calculate the absolute value of a price including a discount.

  • How to fill a formula to cells below by double clicking.

  • How to calculate a shortened value of a price including a discount.

  • How to calculate a value of a price including a discount rounded to one decimal.

  • How to calculate a value of a price including a discount rounded to even tens.

Peter uses Excel 2016 for his demo, but the Excel calculation functions are the same for earlier versions of Excel.









Always the latest news in the kalmstrom.com blog


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

back icon next icon