Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic trial
to watch this video
These functions round a calculation up or down. You can use it to avoid fractional values when calculating things like a number of seats in a stadium, or total number of employees needed to complete a project.
Example Files
 you can continue to use the spreadsheet from the last video, or
 open a copy of this spreadsheet to catch up to this video
Reference
 Documentation for the ROUNDDOWN function for Google Sheets
 Documentation for the ROUNDUP function for Google Sheets
Related Functions

0:00
The round up and round down function help you round values in your formulas.

0:04
This is helpful if you're trying to calculate how many humans you'll need for

0:08
something, or whether or

0:09
not you have enough seating capacity in a stadium, for example.

0:12
Let's walk through an example together.

0:15
Here, we're talking about student to teacher ratios.

0:19
So our goal is to have a student to teacher ratio of 30.

0:23
We have 435 students, so that means that we need 14.5 teachers.

0:29
Now clearly, you can't have half a person,

0:32
so we can use round down or round up to help for this.

0:37
So, I'm gonna hit Enter, then =ROUNDUP to call the function.

0:45
Then we have teachers needed 14.5 and

0:52
I wanna round it to zero decimal places.

0:59
So we round up from 14.5, that gets us 15, so we need 15 teachers.

1:07
Let's say our budget was tight and

1:09
we didn't have the funds to afford to have extra capacity.

1:13
In this situation, we might use the round down function.

1:16
And just deal with the fact that we're gonna have a student to teacher ratio

1:20
above what we want for a little bit of time.

1:23
So the value rounds down to 14.

1:26
We can also do it, instead of referencing the cell above,

1:29
we're actually referencing the calculation we're interested in.

1:33
So I do ROUNDDOWN(C22/C21),

1:43
and we get the same thing.
You need to sign up for Treehouse in order to download course files.
Sign up