Spreadsheet: 44123d1242766942-cell-reference-path-is-keeping-excel-from-seeing-it-as-blank-sample-book-correct-formula
Sheet: Sheet1

RECIPE # (referenced from another workbook | MENU  ITEMS (referenced form another workbook) | COOKING PROCESS | [NAME] (also different workbook) | PORTION      TYPE | MONDAY |  |  |  |  |  |  |  |  |  |  |  |  | IF(ISERR(IF(ISNUMBER(R8),R8/D8,H8/D8)), "", IF(ISNUMBER(R8),R8/D8,H8/D8))
 |  |  |  |  | # X RECIPE | CINDY PLAN TOTAL |  | REIM-BURSED | LEFT OVERS | ALA CARTE | Received | Difference |  |  |  |  |  | IF(OR(C1=0,C1=""), H1/B1, C1/B1))
 |  |  |  |  |  |  | SITE TOTAL |  |  |  |  |  |  |  |  |  |  | (ISERR(R4/D4),"", IF(ISBLANK(R4), H4/D4, R4/D4))
1002 | PIZZA, BREAKFAST, SAUSAGE | SD | 128 | EACH | 3.90625 | 0 | 500 |  |  |  |  | #N/A |  |  |  |  | 0 | IF(N(C1), C1, H1) / B1
631 | OATMEAL & POP TART | SD | 50 | EACH | 0.88 | 44 |  |  |  |  |  | #N/A |  |  | Coming in from another workbook:              ----------> |  | 44
246 | FRUIT, JUICE, ASSORTED | NC | 100 | EACH | 0.32 | 32 |  |  |  |  |  | #N/A |  |  |  |  | 32
437 | PEACHES, CANNED | NC | 48 | 1/4 CUP | 1.770833333333333 | 85 |  |  |  |  |  | #N/A |  |  |  |  | 85
229 | Milk 1% | nc | 1 | each | 1 | 1 | 0 |  |  |  |  | #N/A |  |  |  |  | 1
0 |  |  |  |  | #N/A | 0 |  |  |  |  |  | #N/A |  |  |  |  | 0
644 | PIZZA, PEPPERONI 4X6 100% MOZ. [NAME] | SD | 96 | EACH | 2.083333333333333 | 0 | 200 |  |  |  |  | #N/A |  |  |  |  | 0
557 | BURRITO, BEAN & CHEESE | SD | 72 | EACH | 3.472222222222222 | 0 | 250 |  |  |  |  | #N/A |  |  |  |  | 0
569 | CHIPS, PRETZEL, TINY TWISTS | NC | 120 | EACH | 1.216666666666667 | 146 | 0 |  |  |  |  | #N/A |  |  |  |  | 146
246 | FRUIT, JUICE, ASSORTED | NC | 100 | EACH | 1.74 | 174 |  |  |  |  |  | #N/A |  |  |  |  | 174
0 |  |  |  |  | #N/A | 0 |  |  |  |  |  | #N/A |  |  |  |  | 162.5
0 |  |  |  |  | #N/A | 0 |  |  |  |  |  | #N/A |  |  |  |  | 47.5
0 |  |  |  |  | #N/A | 0 |  |  |  |  |  | #N/A |  |  |  |  | 54
0 |  |  |  |  | #N/A | 3 |  |  |  |  |  | #N/A |  |  |  |  | 183.75
0 |  |  |  |  | #N/A | 0 |  |  |  |  |  | #N/A |  |  |  |  | 429.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 324
 |  |  |  |  | Column I'm having issues with |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | The X recipe should divide the Planned Total by the Portion Size to get how many times a recipe needs to be made |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | If [NAME] enters a planned total, that number should be used. |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | [NAME]'s Planned Total is brought over from another workbook. |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  | (If there is a number in Column G, column H turns black so the site is discouraged from entering a number in a black box… locking it was too difficult) |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | If there is no number in Column G, the Site needs to enter a planned total in column H. |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  |  |  | I would like to keep all errors suppressed, but the fact that information is coming in from other workbooks seems to be throwing things for a loop. It isn't reading the cell as "0" or "", because there is a big ole " Y:Drive/Menu Production Records/ [NAME]'s Workbook/Recipe Planning Worksheet path for it to follow |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0