Gopal asks how to round a number up to the next whole number. Episode 1039 takes a look at several different functions available for rounding numbers in Excel.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically to start out with massive amount of data.
So, how we're going to analyze as well plus file up a pivot table.
Let's see you how can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today's question is sent by Gopal.
Gopal wants to ask about rounding as these two numbers, and once we have a round to this desired result.
Now,It looks like he always wants to round up, to the next highest integer.
Let's just talk about rounding in general first.
Most of the time rounding is done with the ROUND Function.
= ROUND we specify the number, and then how many digits we want to round to.
So, if I wanted to round to the nearest penny, I would say that I wanted to go to two decimal places.
And that will round it off and watch out because that happen to be 90.
It didn't give us enough decimals but you'll see that even if I increase, it is in fact rounding that off correctly.
Now, what if we need to round to the nearest ten dollars.
Well then equal round, that number and you can say, negative 1 digit, that will round up to the nearest 10.
So, ROUND is great for rounding.
there's ten hundred thousand and so on.
Another kind of tricky wise, If we need to round to the nearest nickle, there's something called MROUND.
M stands for multiple.
So, this number run it off the nearest 0.05.
Close brackets and that will round off to the nearest nickle.
But for Gopal's question, where we always want to round up.
There is a pair of Functions.
Round down and round up...
and that number to the nearest 0 digit.
You see that it rounds up in that case and rounds up in that case even though it's just .01 as the decimal.
So there you have, several different options for rounding.
Whether, you need to round two, there's penny nearest ten dollars.
Strange things like rounding off to a nickle or always rounding in one certain direction.
I want to thank you for stopping by.
Well, see you next time for another netcast from MrExcel.
Thanks you for stopping by. We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Basically to start out with massive amount of data.
So, how we're going to analyze as well plus file up a pivot table.
Let's see you how can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today's question is sent by Gopal.
Gopal wants to ask about rounding as these two numbers, and once we have a round to this desired result.
Now,It looks like he always wants to round up, to the next highest integer.
Let's just talk about rounding in general first.
Most of the time rounding is done with the ROUND Function.
= ROUND we specify the number, and then how many digits we want to round to.
So, if I wanted to round to the nearest penny, I would say that I wanted to go to two decimal places.
And that will round it off and watch out because that happen to be 90.
It didn't give us enough decimals but you'll see that even if I increase, it is in fact rounding that off correctly.
Now, what if we need to round to the nearest ten dollars.
Well then equal round, that number and you can say, negative 1 digit, that will round up to the nearest 10.
So, ROUND is great for rounding.
there's ten hundred thousand and so on.
Another kind of tricky wise, If we need to round to the nearest nickle, there's something called MROUND.
M stands for multiple.
So, this number run it off the nearest 0.05.
Close brackets and that will round off to the nearest nickle.
But for Gopal's question, where we always want to round up.
There is a pair of Functions.
Round down and round up...
and that number to the nearest 0 digit.
You see that it rounds up in that case and rounds up in that case even though it's just .01 as the decimal.
So there you have, several different options for rounding.
Whether, you need to round two, there's penny nearest ten dollars.
Strange things like rounding off to a nickle or always rounding in one certain direction.
I want to thank you for stopping by.
Well, see you next time for another netcast from MrExcel.
Thanks you for stopping by. We'll see you next time for another netcast from MrExcel.
