Spreadsheet: 715060d1611532252-trouble-with-if-or-and-formula-test-cfu-warehouse-stock
Sheet: Sheet1

 |  |  |  |  |  |  | Total Stock at Warehouse
 |  |  | Unit No. | Date delivered to warehouse | Invoice No. | Registration | At Warehouse? Yes/No | Zone | Suburb | Unit detail | Holding Yard location | Date of movement from warehouse to holding yard | Estimated Date of Dispatch to final destination | Date of Dispatch to final destination | isnumber column O
 |  |  | 1 | 2020-11-06 00:00:00 | FT0032 | TH41PZ |  | West | Dubbo | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-12-08 00:00:00
 |  |  | 2 | 2020-11-06 00:00:00 | FT0032 | TH44PZ |  | West | Dubbo | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-12-08 00:00:00
 |  |  | 3 | 2020-11-06 00:00:00 | FT0032 | TH49PZ |  | West | Dubbo | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-12-08 00:00:00
 |  |  | 4 | 2020-11-06 00:00:00 | FT0032 | TH42PZ |  | South | [NAME] | New Unit | Petersham | 2021-01-09 00:00:00 | 28/02/2021
 |  |  | 5 | 2020-11-06 00:00:00 | FT0032 | TH45PZ |  | East | [NAME] | New Unit | N/A | N/A | Dispatched | 2020-11-30 00:00:00
 |  |  | 6 | 2020-11-06 00:00:00 | FT0032 | TH40PZ |  | South | Tura Beach | New Unit | Petersham | 2021-01-10 00:00:00 | Dispatched | 2021-01-15 00:00:00
 |  |  | 7 | 2020-11-20 00:00:00 | FT0032 | TH47PZ |  | South | Heathcote | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-11-21 00:00:00
 |  |  | 8 | 2020-11-20 00:00:00 | FT0033 | TH12UR |  | South | Heathcote | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-11-22 00:00:00
 |  |  | 9 | 2020-11-20 00:00:00 | FT0032 | TH46PZ |  | South | Greenleigh | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-11-23 00:00:00
 |  |  | 10 | 2020-11-20 00:00:00 | FT0033 | TH14UR |  | East | Belrose | Replace FHP 141 | N/A | N/A | 25/01/2021
 |  |  | 11 | 2020-11-20 00:00:00 | FT0033 | TH13UR |  | North | Umina Beach | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-11-27 00:00:00
 |  |  | 12 | 2020-11-20 00:00:00 | FT0032 | TH43PZ |  | North | Rankin Park | Upgrade existing MHP | N/A | N/A | 13/02/2021
 |  |  | 13 | 2020-12-04 00:00:00 | FT0033 | TH16UR |  | North | Cherrybrook | Upgrade existing MHP | N/A | N/A
 |  |  | 14 | 2020-12-04 00:00:00 | FT0033 | TH15UR |  | East | [NAME] | Replace FHP-017 | N/A | N/A | 2021-01-18 00:00:00 | 18/01/2021
 |  |  | 15 | 2020-12-04 00:00:00 | FT0033 | TH18UR |  | North | [NAME] | New Unit | N/A | N/A | Dispatched | 2021-01-04 00:00:00
 |  |  | 16 | 2020-11-20 00:00:00 | FT0032 | TH48PZ |  | West | Woodford | New Unit | N/A | N/A | Dispatched | 2020-11-25 00:00:00
 |  |  | 17 | 2020-11-20 00:00:00 | FT0033 | TH11UR |  | South | [NAME] | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-11-21 00:00:00
 |  |  | 18 | 2020-12-04 00:00:00 | FT0033 | TH20UR |  | South | Loftus | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-12-22 00:00:00
 |  |  | 19 | 2020-12-04 00:00:00 | FT0033 | TH17UR |  | South | Menai | Upgrade existing MHP | N/A | N/A | Dispatched | 2020-12-22 00:00:00
 |  |  | 20 | 2020-12-04 00:00:00 | FT0033 | TH19UR |  | North | Hornsby | New Unit | N/A | N/A
 |  |  | 21 |  |  |  |  | Unassigned |  |  | N/A | N/A
 |  |  | 22 |  |  |  |  | Unassigned |  |  | N/A | N/A
 |  |  | 23 | 2020-12-04 00:00:00 |  |  |  | East | North Epping | Upgrade existing MHP | N/A | N/A
 |  |  | 24 |  |  |  |  | East | St Ives | Upgrade existing MHP | N/A | N/A
 |  |  | 25 |  |  |  |  | East | Cromer | Upgrade existing MHP | N/A | N/A
 |  |  | 26 |  |  |  |  | North | Umina Beach | New Unit | N/A | N/A
 |  |  | 27 |  |  |  |  | Unassigned |  |  | N/A | N/A
 |  |  | 28 |  |  |  |  | Unassigned |  |  | N/A | N/A
 |  |  | 29 |  |  |  |  | Unassigned |  |  | N/A | N/A
 |  |  | 30 |  |  |  |  | West | Blackheath | Upgrade existing MHP | N/A | N/A
 |  |  | 31 |  |  |  |  | South | Menai | Upgrade existing MHP | N/A | N/A