I am calculating a percentage between two columns D & G. I want the return value to be blank if column E is blank. The reason column E would be blank is because we didnt count that item so I dont need a percentage.
| IM_WH_COUNT.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | ItemCode | ItemCodeDesc | WarehouseCode | QuantityOnHand | Qty on Shelf | WIP Additions | Updated QTY | Percent Difference | ||
| 141 | 10012552-BLUE-4030 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 55 | 45 | 9 | 54 | -2% | ||
| 143 | 10012552-BLUE-4032 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 63 | 45 | 13 | 58 | -8% | ||
| 145 | 10012552-BLUE-4034 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 54 | 43 | 4 | 47 | -13% | ||
| 147 | 10012552-BLUE-4036 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 63 | 61 | 5 | 66 | 5% | ||
| 149 | 10012552-BLUE-4038 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 0 | 0 | #DIV/0! | ||||
| 150 | 10012552-BLUE-4230 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 39 | 0 | -100% | ||||
| 151 | 10012552-BLUE-4232 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 44 | 0 | -100% | ||||
| 152 | 10012552-BLUE-4234 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 39 | 0 | -100% | ||||
| 153 | 10012552-BLUE-4236 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 45 | 0 | -100% | ||||
| 154 | 10012552-BLUE-4238 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 6 | 0 | -100% | ||||
| 155 | 10012552-BLUE-4430 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 40 | 0 | -100% | ||||
| 156 | 10012552-BLUE-4432 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 51 | 0 | -100% | ||||
| 158 | 10012552-BLUE-4434 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 47 | 0 | -100% | ||||
| 159 | 10012552-BLUE-4436 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 38 | 0 | -100% | ||||
| 160 | 10012552-BLUE-4438 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 0 | 0 | #DIV/0! | ||||
| 161 | 10012552-BLUE-4630 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 30 | 0 | -100% | ||||
| 162 | 10012552-BLUE-4632 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 42 | 0 | -100% | ||||
| 163 | 10012552-BLUE-4634 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 41 | 0 | -100% | ||||
| 164 | 10012552-BLUE-4830 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 1 | 0 | -100% | ||||
| 165 | 10012552-BLUE-4832 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 0 | 0 | #DIV/0! | ||||
| 166 | 10012552-BLUE-4834 | MNS FR M4 RLX BSC BOOT CUT JEA | 000 | 5 | 0 | -100% | ||||
IM_WH_COUNT | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G141,G143,G145,G147,G149:G156,G158:G166 | G141 | =[@[Qty on Shelf]]+[@[WIP Additions]] |
| H141,H143,H145,H147,H149:H156,H158:H166 | H141 | =([@[Updated QTY]]-[@QuantityOnHand])/[@QuantityOnHand] |
