Spreadsheet: 845377d1696916513-formula-to-convert-another-currency-to-usd-bank-sales-for-2022
Sheet: Sales

Kindly asking for the formula to convert ZWL amount to USD amount - column F using the information on Forex Auction rate as shown in column F
 |  |  | ZWL |  | USD
Date | Receipt | Customer | Amount |  | Amount
2022-01-03 00:00:00 |  |  | 28354.95
2022-01-04 00:00:00 |  |  | 11044.5
2022-01-05 00:00:00 |  |  | 6007
2022-01-06 00:00:00 |  |  | 16780.25
2022-01-07 00:00:00 |  |  | 22766.25
2022-01-08 00:00:00 |  |  | 5615.5
2022-01-10 00:00:00 |  |  | 4862.55
2022-01-11 00:00:00 |  |  | 2047.5
2022-01-12 00:00:00 |  |  | 14952
2022-01-13 00:00:00 |  |  | 2394
2022-01-14 00:00:00 |  |  | 16254
2022-01-15 00:00:00 |  |  | 11098.5
2022-01-17 00:00:00 |  |  | 14885
2022-01-18 00:00:00 |  |  | 14742
2022-01-19 00:00:00 |  |  | 13803.5
2022-01-20 00:00:00 |  |  | 3559.5
2022-01-22 00:00:00 |  |  | 8851.5
2022-01-24 00:00:00 |  |  | 29902.9
2022-01-25 00:00:00 |  |  | 7276.5
2022-01-26 00:00:00 |  |  | 9111
2022-01-27 00:00:00 |  |  | 32450.5
2022-01-28 00:00:00 |  |  | 18415.5
2022-01-29 00:00:00 |  |  | 15130.5
2022-01-31 00:00:00 |  |  | 22666.92
2022-02-01 00:00:00 |  |  | 6313.59
2022-02-02 00:00:00 |  |  | 16782.1
2022-02-03 00:00:00 |  |  | 12709.56
2022-02-04 00:00:00 |  |  | 27556.35
2022-02-07 00:00:00 |  |  | 22809.07
2022-02-09 00:00:00 |  |  | 13838.66
2022-02-10 00:00:00 |  |  | 6385.79
2022-02-11 00:00:00 |  |  | 10767.73
2022-02-12 00:00:00 |  |  | 1921.5
2022-02-14 00:00:00 |  |  | 9862.19
2022-02-15 00:00:00 |  |  | 8180.33
2022-02-16 00:00:00 |  |  | 6646.86
2022-02-17 00:00:00 |  |  | 4410.14
2022-02-18 00:00:00 |  |  | 34588.97
2022-02-19 00:00:00 |  |  | 22529
2022-02-22 00:00:00 |  |  | 22353.83
2022-02-22 00:00:00 |  | ZIPIT Transaction | 14467
2022-02-23 00:00:00 |  |  | 6560.29
2022-02-24 00:00:00 |  |  | 9993.3
2022-02-25 00:00:00 |  |  | 29372.41
2022-02-26 00:00:00 |  |  | 38599.5
2022-02-28 00:00:00 |  |  | 23889.4
2022-03-01 00:00:00 |  |  | 17543.77
2022-03-02 00:00:00 |  |  | 13835.7
2022-03-03 00:00:00 |  |  | 12369.87
2022-03-04 00:00:00 |  |  | 11996.87
2022-03-05 00:00:00 |  |  | 4025
2022-03-05 00:00:00 |  | ZIPIT Transaction | 414
2022-03-07 00:00:00 |  |  | 17171.64
2022-03-08 00:00:00 |  |  | 4139.94
2022-03-09 00:00:00 |  |  | 1679.5
2022-03-10 00:00:00 |  |  | 20249.3
2022-03-11 00:00:00 |  |  | 14922.96
2022-03-12 00:00:00 |  |  | 3415.5
2022-03-15 00:00:00 |  |  | 11056.5
2022-03-15 00:00:00 |  |  | 26255
2022-03-16 00:00:00 |  |  | 8926.1
2022-03-17 00:00:00 |  |  | 59102.49
2022-03-21 00:00:00 |  |  | 13921.5
2022-03-22 00:00:00 |  |  | 16220
2022-03-23 00:00:00 |  |  | 3705
2022-03-24 00:00:00 |  |  | 12496.02
2022-03-25 00:00:00 |  | ZIPIT Transaction | 1287
2022-03-25 00:00:00 |  |  | 36213
2022-03-25 00:00:00 |  | UMGUZA VOCATIONAL TRAINING  CENTRE | 7930
2022-03-26 00:00:00 |  |  | 15405
2022-03-28 00:00:00 |  |  | 14789.7
2022-03-29 00:00:00 |  |  | 25199
2022-03-30 00:00:00 |  |  | 15269
2022-03-31 00:00:00 |  |  | 19270.5
2022-04-01 00:00:00 |  |  | 40358
2022-04-02 00:00:00 |  |  | 22885
2022-04-04 00:00:00 |  |  | 9405.5
2022-04-05 00:00:00 |  |  | 5387
2022-04-06 00:00:00 |  |  | 14252
2022-04-07 00:00:00 |  |  | 10437
2022-04-07 00:00:00 |  | ZIPIT Transaction | 1323
2022-04-20 00:00:00 |  |  | 18605
2022-04-21 00:00:00 |  |  | 16190.8
2022-04-22 00:00:00 |  |  | 14045
2022-04-23 00:00:00 |  |  | 13230
2022-04-25 00:00:00 |  |  | 26927.1
2022-04-26 00:00:00 |  | UMGUZA VOCATIONAL TRAINING  CENTRE | 10830
2022-04-26 00:00:00 |  |  | 9815
2022-04-27 00:00:00 |  |  | 9804.65
2022-04-28 00:00:00 |  |  | 23105
2022-04-29 00:00:00 |  |  | 67568.5
2022-04-30 00:00:00 |  |  | 43527
2022-05-03 00:00:00 |  |  | 58772.5
2022-05-04 00:00:00 |  |  | 43989
2022-05-05 00:00:00 |  |  | 39452
2022-05-06 00:00:00 |  |  | 36233
2022-05-07 00:00:00 |  |  | 25146
2022-05-09 00:00:00 |  |  | 36433
2022-05-10 00:00:00 |  |  | 702
2022-05-11 00:00:00 |  |  | 12770
2022-05-12 00:00:00 |  |  | 9405
2022-05-13 00:00:00 |  |  | 43647.5
2022-05-14 00:00:00 |  |  | 23280
2022-05-16 00:00:00 |  |  | 74840
2022-05-17 00:00:00 |  |  | 18060
2022-05-18 00:00:00 |  |  | 4880
2022-05-19 00:00:00 |  |  | 11260
2022-05-20 00:00:00 |  |  | 36462.4
2022-05-21 00:00:00 |  |  | 32220
2022-05-23 00:00:00 |  |  | 33420
2022-05-24 00:00:00 |  |  | 32213.6
2022-05-26 00:00:00 |  |  | 63740
2022-05-27 00:00:00 |  |  | 10649.25
2022-05-28 00:00:00 |  |  | 31965
2022-05-30 00:00:00 |  |  | 20457.5
2022-05-31 00:00:00 |  |  | 36407
2022-06-01 00:00:00 |  |  | 23692.5
2022-06-02 00:00:00 |  |  | 8415
2022-06-03 00:00:00 |  |  | 29497.5
2022-06-04 00:00:00 |  |  | 22650
2022-06-05 00:00:00 |  | NATIONAL UNIVER | 85600
2022-06-06 00:00:00 |  |  | 9862.5
2022-06-07 00:00:00 |  |  | 9445
2022-06-08 00:00:00 |  |  | 10567.5
2022-06-09 00:00:00 |  |  | 11002.5
2022-06-10 00:00:00 |  |  | 4747.5
2022-06-11 00:00:00 |  |  | 9090
2022-06-13 00:00:00 |  |  | 4770
2022-06-14 00:00:00 |  |  | 28395
2022-06-15 00:00:00 |  |  | 8587.5
2022-06-16 00:00:00 |  |  | 8290
2022-06-17 00:00:00 |  |  | 36998.5
2022-06-17 00:00:00 |  | [NAME] | 7500
2022-06-18 00:00:00 |  |  | 130625
2022-06-20 00:00:00 |  |  | 13600
2022-06-21 00:00:00 |  |  | 9275
2022-06-22 00:00:00 |  |  | 13925
2022-06-23 00:00:00 |  |  | 16700
2022-06-24 00:00:00 |  |  | 111610
2022-06-25 00:00:00 |  |  | 26565
2022-06-27 00:00:00 |  |  | 79215.5
2022-06-28 00:00:00 |  |  | 18090
2022-06-29 00:00:00 |  |  | 11190
2022-06-30 00:00:00 |  | NATIONAL UNIVER | 146300
2022-06-30 00:00:00 |  |  | 36810
2022-07-01 00:00:00 |  |  | 56900
2022-07-02 00:00:00 |  |  | 80700
2022-07-04 00:00:00 |  |  | 109235
2022-07-07 00:00:00 |  |  | 40448.5
2022-07-08 00:00:00 |  |  | 28490
2022-07-09 00:00:00 |  |  | 33085
2022-07-11 00:00:00 |  |  | 1820
2022-07-12 00:00:00 |  |  | 9660
2022-07-13 00:00:00 |  |  | 13615
2022-07-14 00:00:00 |  |  | 37915
2022-07-15 00:00:00 |  |  | 110460
2022-07-16 00:00:00 |  |  | 18870
2022-07-18 00:00:00 |  |  | 60240
2022-07-19 00:00:00 |  |  | 27040
2022-07-20 00:00:00 |  |  | 19880
2022-07-21 00:00:00 |  |  | 26120
2022-07-22 00:00:00 |  |  | 57360
2022-07-23 00:00:00 |  |  | 23600
2022-07-25 00:00:00 |  |  | 4600
2022-07-26 00:00:00 |  |  | 12760
2022-07-27 00:00:00 |  |  | 16760
2022-07-28 00:00:00 |  |  | 48040
2022-07-29 00:00:00 |  |  | 130200
2022-08-01 00:00:00 |  |  | 53960
2022-08-02 00:00:00 |  |  | 26520
2022-08-03 00:00:00 |  |  | 4880
2022-08-04 00:00:00 |  |  | 9840
2022-08-05 00:00:00 |  |  | 24160
2022-08-06 00:00:00 |  |  | 15000.2
2022-08-10 00:00:00 |  |  | 36760
2022-08-11 00:00:00 |  |  | 12800
2022-08-12 00:00:00 |  |  | 94840
2022-08-13 00:00:00 |  |  | 90160
2022-08-15 00:00:00 |  |  | 122920
2022-08-15 00:00:00 |  | NAT UNIV OF SCI AND TECHNOLOGY | 223000
2022-08-17 00:00:00 |  |  | 38360
2022-08-18 00:00:00 |  |  | 8320
2022-08-19 00:00:00 |  |  | 11840
2022-08-20 00:00:00 |  |  | 57580
2022-08-22 00:00:00 |  |  | 29960
2022-08-23 00:00:00 |  |  | 7440
2022-08-24 00:00:00 |  |  | 6240
2022-08-25 00:00:00 |  |  | 49200
2022-08-26 00:00:00 |  |  | 52240
2022-08-27 00:00:00 |  |  | 58240
2022-08-29 00:00:00 |  |  | 45368
2022-08-30 00:00:00 |  |  | 14408
2022-08-31 00:00:00 |  |  | 28360
2022-09-01 00:00:00 |  |  | 41800
2022-09-01 00:00:00 |  | 20%Liquidation-Batch | 937.98
2022-09-02 00:00:00 |  |  | 76360
2022-09-03 00:00:00 |  |  | 13160
2022-09-05 00:00:00 |  |  | 51170
2022-09-06 00:00:00 |  |  | 23200
2022-09-07 00:00:00 |  |  | 2320
2022-09-08 00:00:00 |  |  | 29920
2022-09-09 00:00:00 |  |  | 10880
2022-09-10 00:00:00 |  |  | 20040
2022-09-12 00:00:00 |  |  | 8880
2022-09-12 00:00:00 |  | UMGUZA VOCATIONAL TRAINING  CENTRE | 36125
2022-09-13 00:00:00 |  |  | 78680
2022-09-14 00:00:00 |  |  | 60171.5
2022-09-15 00:00:00 |  |  | 63120
2022-09-16 00:00:00 |  |  | 77400
2022-09-17 00:00:00 |  |  | 47580
2022-09-19 00:00:00 |  |  | 34640
2022-09-20 00:00:00 |  |  | 23480
2022-09-21 00:00:00 |  |  | 10840
2022-09-22 00:00:00 |  |  | 73360
2022-09-23 00:00:00 |  |  | 44200
2022-09-24 00:00:00 |  |  | 153480
2022-09-26 00:00:00 |  |  | 50160
2022-09-27 00:00:00 |  |  | 12560
2022-09-28 00:00:00 |  |  | 25400
2022-09-29 00:00:00 |  |  | 39440
2022-09-30 00:00:00 |  |  | 51410
2022-10-01 00:00:00 |  |  | 29640
2022-10-03 00:00:00 |  |  | 31240
2022-10-04 00:00:00 |  |  | 76920
2022-10-05 00:00:00 |  |  | 30760
2022-10-05 00:00:00 |  | ZIPIT Transaction | 6560
2022-10-06 00:00:00 |  |  | 64360
2022-10-07 00:00:00 |  |  | 64080
2022-10-08 00:00:00 |  |  | 32200
2022-10-08 00:00:00 |  | ZIPIT Transaction | 3480
2022-10-10 00:00:00 |  |  | 44520
2022-10-11 00:00:00 |  |  | 5800
2022-10-12 00:00:00 |  |  | 36120
2022-10-13 00:00:00 |  | NATIONAL UNIVERSITY | 57000
2022-10-13 00:00:00 |  | ZIPIT Transaction | 3160
2022-10-13 00:00:00 |  |  | 26320
2022-10-17 00:00:00 |  | ZIPIT Transaction | 5600
2022-10-18 00:00:00 |  | ZIPIT Transaction | 3760
2022-10-18 00:00:00 |  | ZIPIT Transaction | 2880
2022-10-21 00:00:00 |  | ZIPIT Transaction | 1600
2022-10-26 00:00:00 |  | 20%Liquidation-Batch | 15098.3
2022-10-27 00:00:00 |  | ZIPIT Transaction | 7000
2022-10-28 00:00:00 |  | ZIPIT Transaction | 3200
2022-10-29 00:00:00 |  | ZIPIT Transaction | 3280
2022-10-31 00:00:00 |  | ZIPIT Transaction | 7400
2022-11-01 00:00:00 |  | ZIPIT Transaction | 2080
2022-11-03 00:00:00 |  | ZIPIT Transaction | 8720
2022-11-04 00:00:00 |  |  | 56700
2022-11-05 00:00:00 |  |  | 14440
2022-11-07 00:00:00 |  |  | 41560
2022-11-08 00:00:00 |  |  | 6800
2022-11-09 00:00:00 |  |  | 13160
2022-11-09 00:00:00 |  | NAT UNIV OF SCI AND TECHNOLOGY | 499800
2022-11-10 00:00:00 |  |  | 9920
2022-11-11 00:00:00 |  |  | 9200
2022-11-12 00:00:00 |  |  | 45240
2022-11-14 00:00:00 |  |  | 14400
2022-11-15 00:00:00 |  |  | 52840
2022-11-16 00:00:00 |  |  | 38040
2022-11-17 00:00:00 |  |  | 2800
2022-11-18 00:00:00 |  |  | 23680
2022-11-19 00:00:00 |  |  | 9920
2022-11-21 00:00:00 |  |  | 115460
2022-11-22 00:00:00 |  |  | 40720
2022-11-23 00:00:00 |  |  | 66000
2022-11-24 00:00:00 |  |  | 33360
2022-11-25 00:00:00 |  |  | 118440
2022-11-26 00:00:00 |  |  | 116507
2022-11-28 00:00:00 |  |  | 48960
2022-11-29 00:00:00 |  |  | 32120
2022-11-30 00:00:00 |  |  | 25800
2022-12-01 00:00:00 |  |  | 69040
2022-12-02 00:00:00 |  |  | 74160
2022-12-03 00:00:00 |  |  | 40880
2022-12-05 00:00:00 |  |  | 67720
2022-12-06 00:00:00 |  |  | 40400
2022-12-07 00:00:00 |  |  | 51080
2022-12-08 00:00:00 |  |  | 47760
2022-12-09 00:00:00 |  |  | 22040
2022-12-10 00:00:00 |  |  | 29120
2022-12-12 00:00:00 |  |  | 39520
2022-12-13 00:00:00 |  |  | 47362
2022-12-14 00:00:00 |  |  | 106400
2022-12-15 00:00:00 |  |  | 63980
2022-12-16 00:00:00 |  |  | 54540
2022-12-17 00:00:00 |  |  | 13560
2022-12-17 00:00:00 |  | FCB Mobile Banking | 37500
2022-12-17 00:00:00 |  | CABS Mobile Banking | 19000
2022-12-19 00:00:00 |  |  | 162740
2022-12-20 00:00:00 |  |  | 144910
2022-12-21 00:00:00 |  |  | 109855
2022-12-23 00:00:00 |  |  | 406420
2022-12-24 00:00:00 |  |  | 75645
2022-12-28 00:00:00 |  |  | 243495
2022-12-29 00:00:00 |  |  | 95950
2022-12-30 00:00:00 |  |  | 123580
2022-12-31 00:00:00 |  |  | 64485