1
00:00:00,230 --> 00:00:04,700
The round up and round down function
help you round values in your formulas.

2
00:00:04,700 --> 00:00:08,030
This is helpful if you're trying to
calculate how many humans you'll need for

3
00:00:08,030 --> 00:00:09,140
something, or whether or

4
00:00:09,140 --> 00:00:12,570
not you have enough seating
capacity in a stadium, for example.

5
00:00:12,570 --> 00:00:15,600
Let's walk through an example together.

6
00:00:15,600 --> 00:00:19,150
Here, we're talking about
student to teacher ratios.

7
00:00:19,150 --> 00:00:23,280
So our goal is to have a student
to teacher ratio of 30.

8
00:00:23,280 --> 00:00:29,990
We have 435 students, so
that means that we need 14.5 teachers.

9
00:00:29,990 --> 00:00:32,420
Now clearly, you can't have half a person,

10
00:00:32,420 --> 00:00:37,120
so we can use round down or
round up to help for this.

11
00:00:37,120 --> 00:00:45,470
So, I'm gonna hit Enter,
then =ROUNDUP to call the function.

12
00:00:45,470 --> 00:00:52,656
Then we have teachers needed 14.5 and

13
00:00:52,656 --> 00:00:59,641
I wanna round it to zero decimal places.

14
00:00:59,641 --> 00:01:07,082
So we round up from 14.5,
that gets us 15, so we need 15 teachers.

15
00:01:07,082 --> 00:01:09,183
Let's say our budget was tight and

16
00:01:09,183 --> 00:01:13,300
we didn't have the funds to
afford to have extra capacity.

17
00:01:13,300 --> 00:01:16,470
In this situation,
we might use the round down function.

18
00:01:16,470 --> 00:01:20,954
And just deal with the fact that we're
gonna have a student to teacher ratio

19
00:01:20,954 --> 00:01:23,527
above what we want for
a little bit of time.

20
00:01:23,527 --> 00:01:26,202
So the value rounds down to 14.

21
00:01:26,202 --> 00:01:29,401
We can also do it,
instead of referencing the cell above,

22
00:01:29,401 --> 00:01:33,274
we're actually referencing
the calculation we're interested in.

23
00:01:33,274 --> 00:01:43,166
So I do ROUNDDOWN(C22/C21),

24
00:01:43,166 --> 00:01:49,970
and we get the same thing.