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.