In Easy Steps Articles

April 13, 2022

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

Sign up to our

Newsletter

Our newsletters inform you of new and forthcoming titles, handy tips, and other updates and special offers. You can opt out anytime.

"*" indicates required fields

By In Easy Steps Team

Share