1
00:00:00,080 --> 00:00:02,224
A production rate shows #DIV/0!

2
00:00:02,224 --> 00:00:05,083
because the Hours cell is zero or empty.

3
00:00:05,083 --> 00:00:09,014
The safe result in our exercise is eight for the completed

4
00:00:09,014 --> 00:00:12,230
packing row and blank for the two undefined rates.

5
00:00:12,230 --> 00:00:16,160
We will inspect the divisor, use a narrow IF guard, and

6
00:00:16,160 --> 00:00:17,590
check every original input.

7
00:00:17,590 --> 00:00:21,521
A blank rate means it cannot be calculated yet; it does

8
00:00:21,521 --> 00:00:23,665
not mean zero work was completed.

9
00:00:24,265 --> 00:00:29,996
In a workbook copy, put the three practice rows in columns A through C.

10
00:00:29,996 --> 00:00:33,272
Put =B2/C2 in D2 and fill down.

11
00:00:33,272 --> 00:00:38,594
Packing returns eight, while a zero or blank hours cell produces #DIV/0!.

12
00:00:38,594 --> 00:00:43,507
Select a failing formula and inspect column C before touching the result.

13
00:00:44,107 --> 00:00:47,390
The number of completed units is not the problem.

14
00:00:47,390 --> 00:00:49,943
A rate needs time in the denominator.

15
00:00:49,943 --> 00:00:53,955
For this exercise, a zero or missing hours value means the

16
00:00:53,955 --> 00:00:55,778
rate is unavailable, not zero.

17
00:00:55,778 --> 00:00:59,790
Do not replace a missing hours value with one merely to

18
00:00:59,790 --> 00:01:01,249
make the error disappear.

19
00:01:01,849 --> 00:01:07,981
In D2 enter =IF(OR(C2="",C2=0),"",B2/C2) and fill it through D4.

20
00:01:07,981 --> 00:01:12,477
The OR test catches both a blank cell and an explicit

21
00:01:12,477 --> 00:01:14,112
zero before division occurs.

22
00:01:14,112 --> 00:01:18,609
This is narrower than wrapping the whole formula in IFERROR, which

23
00:01:18,609 --> 00:01:22,288
could also hide a mistyped numerator or other error.

24
00:01:22,888 --> 00:01:27,425
Packing still shows eight because twenty-four divided by three is eight.

25
00:01:27,425 --> 00:01:30,449
Labeling and Setup now display blank result cells.

26
00:01:30,449 --> 00:01:34,608
The source data should remain twelve units with zero hours and

27
00:01:34,608 --> 00:01:36,498
eighteen units with missing hours.

28
00:01:36,498 --> 00:01:40,657
Compare each row, not just the absence of an error badge.

29
00:01:41,257 --> 00:01:45,598
If a row still shows #DIV/0!, select its formula and inspect

30
00:01:45,598 --> 00:01:47,044
the actual denominator reference.

31
00:01:47,044 --> 00:01:51,385
It may point at a different cell after a copy or sort.

32
00:01:51,385 --> 00:01:55,725
If you see another error instead, do not hide it with IFERROR.

33
00:01:55,725 --> 00:02:00,789
Repair that formula or input on a separate copy and rerun the row check.

34
00:02:01,389 --> 00:02:04,674
Compare your own practice copy with the answer check.

35
00:02:04,674 --> 00:02:06,864
Packing is 8 units per hour.

36
00:02:06,864 --> 00:02:10,879
Labeling and Setup have no defined rate because their hours are

37
00:02:10,879 --> 00:02:14,164
zero and blank respectively; their result cells stay blank.

38
00:02:14,164 --> 00:02:16,719
A blank result is not zero productivity.

39
00:02:16,719 --> 00:02:19,274
The original units and hours remain unchanged.

40
00:02:19,274 --> 00:02:23,289
If the result differs, revisit the source data and the specific

41
00:02:23,289 --> 00:02:25,479
step rather than hiding the symptom.

42
00:02:25,479 --> 00:02:29,495
The matching written guide includes the exercise and primary product references.