#304 Round & Round We Go

If I round everything up, does that make me an optimist?  No matter which way you need to round your numbers, I’m positive that Excel has an option for you. 😎

This week I’d like to share some common Excel number rounding functions that might come in handy for you.

Formula What it does?
ROUND Rounds a number to specified decimal points (or multiples of 10)
ROUNDUP Rounds up a number
ROUNDDOWN Rounds down a number
MROUND Rounds to nearest multiple of specified number
INT Rounds down to nearest integer
CEILING Rounds up a number to nearest multiple of 1,10,100…
FLOOR Rounds down a number to nearest multiple of 1,10,100…
EVEN Gives next even number
ODD Gives next odd number
FIXED Rounds and converts to text format (with commas if you want)

Let’s take a quick look at some examples:

Download a sample spreadsheet to learn more.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s