How to use the Rounding function in Excel

A frequently required capability in Excel worksheets is Rounding. The Math functions list includes 10 such functions:

  • CEILING.MATH
  • EVEN
  • FLOOR.MATH
  • INT
  • MROUND
  • ODD
  • ROUNDROUNDDOWN
  • ROUNDUP
  • TRUNC

The following worksheet illustrates some of these functions being applied to positive and negative numbers.

 

Find more tips like this in Excel Functions & Formulas in easy steps

£11.99

192 pages
By Michael Price
ISBN: 9781840788815