Spreadsheet: 810578d1671862175-logical-formula-if-functions-with-if-not-isna-logical-formula
Sheet: Sheet9

Date | Rate |  |  |  |  |  |  |  | Date | Rate
04/27/2022 |  |  |  |  |  |  |  |  | 04/27/2022 | -0.52
05/27/2022 |  |  |  |  |  |  |  |  | 04/28/2022 | -0.522
2022-05-28 00:00:00 |  |  |  |  |  |  |  |  | 04/29/2022 | -0.538
06/27/2022 |  |  |  |  |  |  |  |  | 05/02/2022 | -0.527
07/27/2022 |  |  |  |  |  |  |  |  | 05/03/2022 | -0.543
08/27/2022 |  |  |  |  |  |  |  |  | 05/04/2022 | -0.544
[NAME] |  |  |  |  |  |  |  |  | 05/05/2022 | -0.553
10/27/2022 |  |  |  |  |  |  |  |  | 05/06/2022 | -0.553
 |  |  |  |  |  |  |  |  | 05/09/2022 | -0.533
 |  |  |  |  |  |  |  |  | 05/10/2022 | -0.553
 |  |  |  |  |  |  |  |  | 05/11/2022 | -0.566
 |  |  |  |  |  |  |  |  | 05/12/2022 | -0.544
 |  |  |  |  |  |  |  |  | 05/13/2022 | -0.546
 |  |  |  |  |  |  |  |  | 05/16/2022 | -0.558
 |  |  |  |  |  |  |  |  | 05/17/2022 | -0.544
 |  |  |  |  |  |  |  |  | 05/18/2022 | -0.552
 |  |  |  |  |  |  |  |  | 05/19/2022 | -0.542
 |  |  |  |  |  |  |  |  | 05/20/2022 | -0.535
 |  |  |  |  |  |  |  |  | 05/23/2022 | -0.543
 |  |  |  |  |  |  |  |  | 05/24/2022 | -0.543
 |  |  |  |  |  |  |  |  | 05/25/2022 | -0.547
 |  |  |  |  |  |  |  |  | 05/26/2022 | -0.544
 |  |  |  |  |  |  |  |  | 05/27/2022 | -0.545
 |  |  |  |  |  |  |  |  | [NAME] | -0.545
 |  |  |  |  |  |  |  |  | 05/31/2022 | -0.546
 |  |  |  |  |  |  |  |  | [NAME] | -0.541
 |  |  |  |  |  |  |  |  | [NAME] | -0.538
 |  |  |  |  |  |  |  |  | 06/03/2022 | -0.538
 |  |  |  |  |  |  |  |  | 06/06/2022 | -0.531
 |  |  |  |  |  |  |  |  | 06/07/2022 | -0.525
 |  |  |  |  |  |  |  |  | 06/08/2022 | -0.537
 |  |  |  |  |  |  |  |  | 06/09/2022 | -0.533
 |  |  |  |  |  |  |  |  | 06/10/2022 | -0.539
 |  |  |  |  |  |  |  |  | 06/13/2022 | -0.536
 |  |  |  |  |  |  |  |  | 06/14/2022 | -0.512
 |  |  |  |  |  |  |  |  | 06/15/2022 | -0.494
 |  |  |  |  |  |  |  |  | 06/16/2022 | -0.498
 |  |  |  |  |  |  |  |  | [NAME] | -0.487
 |  |  |  |  |  |  |  |  | 06/20/2022 | -0.5
 |  |  |  |  |  |  |  |  | 06/21/2022 | -0.512
 |  |  |  |  |  |  |  |  | 06/22/2022 | -0.512
 |  |  |  |  |  |  |  |  | 06/23/2022 | -0.528
 |  |  |  |  |  |  |  |  | 06/24/2022 | -0.553
 |  |  |  |  |  |  |  |  | 06/27/2022 | -0.551
 |  |  |  |  |  |  |  |  | 06/28/2022 | -0.536
 |  |  |  |  |  |  |  |  | 06/29/2022 | -0.535
 |  |  |  |  |  |  |  |  | 06/30/2022 | -0.508
 |  |  |  |  |  |  |  |  | 07/01/2022 | -0.506
 |  |  |  |  |  |  |  |  | 07/04/2022 | -0.485
 |  |  |  |  |  |  |  |  | 07/05/2022 | -0.46
 |  |  |  |  |  |  |  |  | 07/06/2022 | -0.465
 |  |  |  |  |  |  |  |  | 07/07/2022 | -0.464
 |  |  |  |  |  |  |  |  | 07/08/2022 | -0.427
 |  |  |  |  |  |  |  |  | 07/11/2022 | -0.398
 |  |  |  |  |  |  |  |  | 07/12/2022 | -0.4
 |  |  |  |  |  |  |  |  | 07/13/2022 | -0.421
 |  |  |  |  |  |  |  |  | 07/14/2022 | -0.378
 |  |  |  |  |  |  |  |  | 07/15/2022 | -0.317
 |  |  |  |  |  |  |  |  | 07/18/2022 | -0.32
 |  |  |  |  |  |  |  |  | 07/19/2022 | -0.325
 |  |  |  |  |  |  |  |  | 07/20/2022 | -0.259
 |  |  |  |  |  |  |  |  | 07/21/2022 | -0.252
 |  |  |  |  |  |  |  |  | 07/22/2022 | -0.17
 |  |  |  |  |  |  |  |  | 07/25/2022 | -0.131
 |  |  |  |  |  |  |  |  | 07/26/2022 | -0.089
 |  |  |  |  |  |  |  |  | 07/27/2022 | -0.062
 |  |  |  |  |  |  |  |  | 07/28/2022 | -0.035
 |  |  |  |  |  |  |  |  | 07/29/2022 | -0.071
 |  |  |  |  |  |  |  |  | 08/01/2022 | -0.062
 |  |  |  |  |  |  |  |  | 08/02/2022 | -0.048
 |  |  |  |  |  |  |  |  | 08/03/2022 | -0.04
 |  |  |  |  |  |  |  |  | 08/04/2022 | -0.039
 |  |  |  |  |  |  |  |  | 08/05/2022 | -0.041
 |  |  |  |  |  |  |  |  | 08/08/2022 | -0.032
 |  |  |  |  |  |  |  |  | 08/09/2022 | -0.015
 |  |  |  |  |  |  |  |  | 08/10/2022 | -0.025
 |  |  |  |  |  |  |  |  | 08/11/2022 | -0.027
 |  |  |  |  |  |  |  |  | 08/12/2022 | -0.035
 |  |  |  |  |  |  |  |  | 08/15/2022 | -0.016
 |  |  |  |  |  |  |  |  | 08/16/2022 | -0.028
 |  |  |  |  |  |  |  |  | 08/17/2022 | -0.014
 |  |  |  |  |  |  |  |  | [NAME] | 0.003
 |  |  |  |  |  |  |  |  | 08/19/2022 | 0.026
 |  |  |  |  |  |  |  |  | 08/22/2022 | 0.046
 |  |  |  |  |  |  |  |  | 08/23/2022 | 0.059
 |  |  |  |  |  |  |  |  | 08/24/2022 | 0.079
 |  |  |  |  |  |  |  |  | 08/25/2022 | 0.085
 |  |  |  |  |  |  |  |  | 08/26/2022 | 0.094
 |  |  |  |  |  |  |  |  | 08/29/2022 | 0.12
 |  |  |  |  |  |  |  |  | 08/30/2022 | 0.196
 |  |  |  |  |  |  |  |  | 08/31/2022 | 0.23
 |  |  |  |  |  |  |  |  | [NAME] | 0.228
 |  |  |  |  |  |  |  |  | 09/02/2022 | 0.314
 |  |  |  |  |  |  |  |  | 09/05/2022 | 0.298
 |  |  |  |  |  |  |  |  | 09/06/2022 | 0.368
 |  |  |  |  |  |  |  |  | 09/07/2022 | 0.394
 |  |  |  |  |  |  |  |  | 09/08/2022 | 0.381
 |  |  |  |  |  |  |  |  | 09/09/2022 | 0.48
 |  |  |  |  |  |  |  |  | 09/12/2022 | 0.586
 |  |  |  |  |  |  |  |  | [NAME] | 0.619
 |  |  |  |  |  |  |  |  | 09/14/2022 | 0.669
 |  |  |  |  |  |  |  |  | 09/15/2022 | 0.68
 |  |  |  |  |  |  |  |  | [NAME] | 0.678
 |  |  |  |  |  |  |  |  | 09/19/2022 | 0.692
 |  |  |  |  |  |  |  |  | 09/20/2022 | 0.7
 |  |  |  |  |  |  |  |  | 09/21/2022 | 0.708
 |  |  |  |  |  |  |  |  | 09/22/2022 | 0.68
 |  |  |  |  |  |  |  |  | 09/23/2022 | 0.698
 |  |  |  |  |  |  |  |  | 09/26/2022 | 0.7
 |  |  |  |  |  |  |  |  | [NAME] | 0.722
 |  |  |  |  |  |  |  |  | [NAME] | 0.685
 |  |  |  |  |  |  |  |  | 09/29/2022 | 0.666
 |  |  |  |  |  |  |  |  | 09/30/2022 | 0.679
 |  |  |  |  |  |  |  |  | 10/03/2022 | 0.674
 |  |  |  |  |  |  |  |  | 10/04/2022 | 0.664
 |  |  |  |  |  |  |  |  | 10/05/2022 | 0.706
 |  |  |  |  |  |  |  |  | 10/06/2022 | 0.733
 |  |  |  |  |  |  |  |  | 10/07/2022 | 0.783
 |  |  |  |  |  |  |  |  | 10/10/2022 | 0.809
 |  |  |  |  |  |  |  |  | [NAME] | 0.843
 |  |  |  |  |  |  |  |  | 10/12/2022 | 0.854
 |  |  |  |  |  |  |  |  | 10/13/2022 | 0.845
 |  |  |  |  |  |  |  |  | 10/14/2022 | 0.892
 |  |  |  |  |  |  |  |  | 10/17/2022 | 0.913
 |  |  |  |  |  |  |  |  | 10/18/2022 | 0.919
 |  |  |  |  |  |  |  |  | 10/19/2022 | 0.938
 |  |  |  |  |  |  |  |  | 10/20/2022 | 0.943
 |  |  |  |  |  |  |  |  | 10/21/2022 | 0.983
 |  |  |  |  |  |  |  |  | 10/24/2022 | 0.979
 |  |  |  |  |  |  |  |  | 10/25/2022 | 1.038
 |  |  |  |  |  |  |  |  | 10/26/2022 | 1.109
 |  |  |  |  |  |  |  |  | 10/27/2022 | 1.133
 |  |  |  |  |  |  |  |  | 10/28/2022 | 1.208
 |  |  |  |  |  |  |  |  | 10/31/2022 | 1.253
 |  |  |  |  |  |  |  |  | 11/01/2022 | 1.376
 |  |  |  |  |  |  |  |  | 11/02/2022 | 1.385
 |  |  |  |  |  |  |  |  | 11/03/2022 | 1.401
 |  |  |  |  |  |  |  |  | 11/04/2022 | 1.398
 |  |  |  |  |  |  |  |  | 11/07/2022 | 1.405
 |  |  |  |  |  |  |  |  | 11/08/2022 | 1.415
 |  |  |  |  |  |  |  |  | 11/09/2022 | 1.415
 |  |  |  |  |  |  |  |  | 11/10/2022 | 1.395
 |  |  |  |  |  |  |  |  | 11/11/2022 | 1.362
 |  |  |  |  |  |  |  |  | 11/14/2022 | 1.405
 |  |  |  |  |  |  |  |  | 11/15/2022 | 1.414
 |  |  |  |  |  |  |  |  | 11/16/2022 | 1.395
 |  |  |  |  |  |  |  |  | 11/17/2022 | 1.425
 |  |  |  |  |  |  |  |  | 11/18/2022 | 1.413
 |  |  |  |  |  |  |  |  | 11/21/2022 | 1.4
 |  |  |  |  |  |  |  |  | 11/22/2022 | 1.418
 |  |  |  |  |  |  |  |  | 11/23/2022 | 1.448
 |  |  |  |  |  |  |  |  | 11/24/2022 | 1.462
 |  |  |  |  |  |  |  |  | 11/25/2022 | 1.476
 |  |  |  |  |  |  |  |  | 11/28/2022 | 1.492
 |  |  |  |  |  |  |  |  | 11/29/2022 | 1.497
 |  |  |  |  |  |  |  |  | 11/30/2022 | 1.512
 |  |  |  |  |  |  |  |  | 12/01/2022 | 1.526
 |  |  |  |  |  |  |  |  | 12/02/2022 | 1.514
 |  |  |  |  |  |  |  |  | [NAME] | 1.523
 |  |  |  |  |  |  |  |  | [NAME] | 1.519
 |  |  |  |  |  |  |  |  | 12/07/2022 | 1.552