Spreadsheet: 733483d1621597930-multiple-if-functions-test-solved
Sheet: Sheet1

 |  | Supplier | Order Date | Ordered (M) | ETD | ETA |  | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  | Deposit | Balance |  | Deposit £ | Balance £
 | T/A/C | AKS |  |  | May | June | RJ-39 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-23 00:00:00 |  |  | 19120.66 | USD
 | A/C/SA | AKS |  |  | May | June | RJ-51 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-23 00:00:00 |  |  | 18546.33 | USD
 | All 5 | AKS |  |  | May | June | RJ-54 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-18 00:00:00 |  |  | 16808.39 | USD |  |  | USD | 1.41
 | SA/T/A | AKS |  |  | May | June | RJ-57 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-10 00:00:00 |  | 2123.18 |  | USD |  |  | CNY | 9
 | SA/A/C | AKS |  |  | May | June | RJ-58 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-16 00:00:00 |  |  | 21231.75 | USD
 | SA/T/A | AKS |  |  | May | June | RJ-79 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-18 00:00:00 |  |  | 21231.75 | USD
 | S/A/C | AKS |  |  |  |  | RJ-80 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-16 00:00:00 |  |  | 21231.75 | USD
SW | 27 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43320.61 | 173282.46 | CNY
SW | 28 | Oakio | 2021-03-11 00:00:00 | March | June | July | RJ-91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40208.11 | 160832.46 | CNY
DB | 29 | Oakio | 2021-03-11 00:00:00 | March | May | June | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
DB | 30 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
DG | 31 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
DG | 32 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
LG | 33 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
LG | 34 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35795.49 | 143181.97 | CNY
Cladding | 35 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37102.84 | 148411.38 | CNY
Cladding | 36 | Oakio | 2021-03-11 00:00:00 | March | May | June | RJ-99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36651.67 | 146606.67 | CNY
SW | 37 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41580.43 | 166321.73 | CNY
SW | 38 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41580.43 | 166321.73 | CNY
SW | 39 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-102 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41580.43 | 166321.73 | CNY
SW | 40 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41580.43 | 166321.73 | CNY
LG | 41 | Oakio | 2021-04-21 00:00:00 | April | June | July | RJ-104 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49843.25 | 199372.98 | CNY
LG | 42 | Oakio | 2021-04-21 00:00:00 | April | June | July | RJ-105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46945.25 | 187780.98 | CNY
LG | 43 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-106 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
LG | 44 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
DG | 45 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
DG | 46 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
DG | 47 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
DG | 48 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
LG | 49 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-112 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38313.25 | 153252.98 | CNY
Cladding | 50 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-113 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37636.27 | 150545.09 | CNY
Cladding | 51 | Oakio | 2021-04-21 00:00:00 | April |  |  | RJ-114 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37516.24 | 150064.96 | CNY
 | Fence DG | AKS | 2021-04-01 00:00:00 | April | May | June | RJ-132 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-12 00:00:00 |  | 1342.3 | 12080.7 | USD
 | Fence DG | AKS | 2021-04-01 00:00:00 | April | May | June | RJ-133 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-12 00:00:00 |  | 1342.3 | 12080.7 | USD
 | Fence CG | AKS | 2021-04-01 00:00:00 | April | May | June | RJ-134 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-12 00:00:00 |  | 1342.3 | 12080.7 | USD
 | Fence CG | AKS | 2021-04-01 00:00:00 | April | May | June | RJ-135 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-12 00:00:00 |  | 1342.3 | 12080.7 | USD
 | Cocklestorm | AKS | 2021-03-18 00:00:00 | March | May | June | RJ-138 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-18 00:00:00 |  |  | 21696.38 | USD
 | Cocklestorm | AKS | 2021-03-18 00:00:00 | March |  |  | RJ-139 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21509.07 | USD
 | Black | AKS | 2021-03-26 00:00:00 | March | May | June | RJ-140 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-18 00:00:00 |  |  | 21136.4 | USD
 | Silver | AKS | 2021-03-26 00:00:00 | March |  |  | RJ-141 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | [NAME] | AKS | 2021-03-26 00:00:00 | March |  |  | RJ-142 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | Silver | AKS | 2021-03-26 00:00:00 | March |  |  | RJ-143 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | Black | AKS | 2021-03-26 00:00:00 | March |  |  | RJ-144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | Chocolate | AKS |  |  |  |  | RJ-145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | Slate | AKS |  |  |  |  | RJ-146 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | Slate | AKS |  |  |  |  | RJ-147 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | SA | AKS |  |  |  |  | RJ-148 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | SA | AKS |  |  |  |  | RJ-149 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | SA | AKS |  |  |  |  | RJ-150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | SA | AKS |  |  |  |  | RJ-151 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | Teak | AKS |  |  |  |  | RJ-152 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | Silver | AKS |  |  |  |  | RJ-153 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | [NAME] | AKS |  |  |  |  | RJ-154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | Black | AKS |  |  |  |  | RJ-155 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21136.4 | USD
 | Fence | AKS |  |  |  |  | RJ-156 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | SA+S&E | AKS |  |  |  |  | RJ-157 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21844.16 | USD
 | SA+S&E | AKS |  |  |  |  | RJ-158 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21844.16 | USD
 | Teak | AKS |  |  |  |  | RJ-159 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21731.75 | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-161 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-162 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-164 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Cocklestorm | AKS | 2021-05-13 00:00:00 |  |  |  | RJ-165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 | Railing | ForeStar | 2021-05-13 00:00:00 |  |  |  | RJ-166 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2976.3 | 26786.7 | USD
 | Railing | ForeStar | 2021-05-13 00:00:00 |  |  |  | RJ-167 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2911.95 | 26207.55 | USD