Spreadsheet: 849943d1700308295-formula-showing-wrong-result-formula-not-working-perfectly-statement-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | URBAN Bank
CONT NO. 492 |  |  |  |  |  |  |  | [NAME]. 6008648 |  | voucher inserted
DATE. 23.10.23 |  |  |  |  |  |  |  |  |  | 06.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 911 | 2023-10-25 00:00:00 | MH30/AV-1269 | 160 | 14.39 | 14.38 |  | 492
65 | 2023-10-23 00:00:00 | SOPAN TRADERS | 1294.61 | 4561.141193100625 | 103336 | 5167 | 5580 |  |  |  | 601077 |  | 912 | 2023-10-25 00:00:00 | MH32/Q-2195 | 165 | 14.81 | 14.79 |  | 492
39 | 2023-10-23 00:00:00 | PURUSHOTTAM LAXMINARAYAN AGRAWAL | 448.63 | 4584.194102044001 | 35991 | 1800 | 1934 |  |  |  | 601078 |  | 913 | 2023-10-25 00:00:00 | MH27/X-5988 | 170 | 15.34 | 15.35 |  | 492
844 | 2023-10-23 00:00:00 | SHRI CHAKRADHAR SWAMI TRADERS | 209.46 | 4537.491645182851 | 16632 | 832 | 903 |  |  |  | 601079 |  | 914 | 2023-10-25 00:00:00 | MH43/U-3303 | 220 | 19.78 | 19.79 |  | 492
58 | 2023-10-23 00:00:00 | PAYAL TRADERS | 162.83 | 4600 | 13107 | 656 | 703 |  |  |  | 601080 |  | 915 | 2023-10-25 00:00:00 | MH27/BX-2183 | 300 | 26.86 | 26.88 |  | 492
 |  |  |  |  |  |  |  |  |  |  |  |  | 916 | 2023-10-25 00:00:00 | MH28/B-7019 | 217 | 19.54 | 19.54 |  | 492
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 917 | 2023-10-25 00:00:00 | MH31/W-3381 | 210 | 18.84 | 18.84 |  | 492
 |  |  |  |  |  |  |  |  |  |  |  |  | 918 | 2023-10-25 00:00:00 | MH32/[NAME] | 320 | 28.8 | 28.76 |  | 492
 |  |  | QTY1 | RATE |  |  |  |  |  |  |  |  | 919 | 2023-10-25 00:00:00 | MH40/BL-1604 | 320 | 28.78 | 28.76 |  | 492 |  |  |  |  |  |  |  | 1300903
 |  |  |  |  |  |  |  |  |  |  |  |  | 920 | 2023-10-25 00:00:00 | MH27/X-501 | 281 | 25.27 | 25.28 |  | 492 |  |  |  |  |  |  |  | 1142244.753149329
 |  |  |  |  |  |  |  |  |  |  |  |  | 931 | 2023-10-27 00:00:00 | MH42/B-7678 | 11 | 0.997 | 0.997 |  | 495
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 211.553
 |  |  |  |  |  |  |  |  |  | URBAN BANK
CONT NO. 495 |  |  |  |  |  |  |  |  |  | voucher inserted
DATE. 26.10.23 |  |  |  |  |  |  |  |  |  | 08.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 934 | 2023-10-27 00:00:00 | MH40/BL-1604 | 330 | 29.75 | 29.74 |  | 495
9 | 2023-10-26 00:00:00 | SOPAN TRADERS | 1245.69 | 4528.510303526559 | 98720 | 4936 | 5368 |  |  |  | 601081 |  | 937 | 2023-10-28 00:00:00 | MH04/EY-7678 | 285 | 25.62 | 25.62 |  | 495
122 | 2023-10-26 00:00:00 | MANASAMATA TRADERS | 130.98 | 4550.007634753398 | 10429 | 522 | 564 |  |  |  | 601082 |  | 938 | 2023-10-28 00:00:00 | MH27/BX-0016 | 370 | 33.23 | 33.19 |  | 495
71 | 2023-10-26 00:00:00 | PAYAL TRADERS | 119.39 | 4573.465114331184 | 9555 | 478 | 515 |  |  |  | 601083 |  | 935 | 2023-10-28 00:00:00 | MH27/X-501 | 330 | 29.64 | 29.62 |  | 495
2724 | 2023-10-26 00:00:00 | BASAPPA GOVINDAPPA BAJARE | 211.84 | 4530.806268882176 | 16796 | 840 | 911 |  |  |  | 601084 |  | 936 | 2023-10-28 00:00:00 | MH32/[NAME] | 320 | 28.79 | 28.77 |  | 495
 |  |  |  |  |  |  |  |  |  |  |  |  | 941 | 2023-10-28 00:00:00 | MH40/BL-1604 | 68 | 6.16 | 6.16 |  | 495
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 939 | 2023-10-28 00:00:00 | MH28/AB-7013 | 217 | 19.52 | 19.5 |  | 495
 |  |  | QTY2 | RATE |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 170.79
 |  |  |  |  |  |  |  |  |  | URBAN Bank
CONT NO. 497 |  |  |  |  |  |  |  |  |  | voucher inserted
DATE. 27.10.23 |  |  |  |  |  |  |  |  |  | 08.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 940 | 2023-10-28 00:00:00 | MH27/BQ-4555 | 304 | 25.23 | 25.22 |  | 497
17 | 2023-10-27 00:00:00 | SOPAN TRADERS | 404.58 | 4596.841168619309 | 32546 | 1628 | 1744 |  |  |  | 601092 |  | 930 | 2023-10-27 00:00:00 | MH28/AB-7013 | 217 | 19.47 | 19.46 |  | 495
2388 | 2023-10-27 00:00:00 | UMESH RAMESHRAV SAGANE | 61.69 | 4551.661533473821 | 4914 | 246 | 266 |  |  |  | 601093 |  | 931 | 2023-10-27 00:00:00 | MH42/B-7678 | 172 | 15.503 | 15.503 |  | 495
73 | 2023-10-27 00:00:00 | PAYAL TRADERS | 175.19 | 4615.160682687369 | 14149 | 708 | 757 |  |  |  | 601094 |  | 941 | 2023-10-28 00:00:00 | MH40/BL-1604 | 53 | 4.689 | 4.689 |  | 495
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 64.146
 |  |  | [NAME] | RATE
CONT NO. 500
DATE. 30.10.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 961 | 2023-11-01 00:00:00 | MH30/AB-2576 | 302 | 27.18 | 27.18 |  | 500
36 | 2023-10-30 00:00:00 | SOPAN TRADERS | 2358.21 | 4730.490075099334 | 195211 | 9765 | 10159 |  |  |  |  |  | 948 | 2023-10-31 00:00:00 | MH28/AB-7013 | 217 | 19.54 | 19.53 |  | 500
2733 | 2023-10-30 00:00:00 | BASAPPA GOVINDAPPA BAJARE | 236.02 | 4736.217269722904 | 19560 | 978 | 1015 |  |  |  |  |  | 955 | 2023-10-31 00:00:00 | MH32/[NAME] | 330 | 29.69 | 29.69 |  | 500
86 | 2023-10-30 00:00:00 | PAYAL TRADERS | 300.94 | 4779.999335415698 | 25174 | 1259 | 1300 |  |  |  |  |  | 956 | 2023-10-31 00:00:00 | MH40/N-5220 | 300 | 26.99 | 27.01 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  | 957 | 2023-10-31 00:00:00 | MH12/FZ-7033 | 285 | 25.59 | 25.58 |  | 500
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 958 | 2023-10-31 00:00:00 | MH27/BX-3337 | 285 | 25.65 | 25.61 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  | 959 | 2023-10-31 00:00:00 | MH27/BQ-4555 | 284 | 25.52 | 25.5 |  | 500
 |  |  | [NAME] | RATE |  |  |  |  |  |  |  |  | 960 | 2023-10-31 00:00:00 | MH27/BX-6716 | 280 | 25.15 | 25.13 |  | 500 |  |  |  |  | 1178940
 |  |  |  |  |  |  |  |  |  |  |  |  | 950 | 2023-10-31 00:00:00 | MH30/AB-2576 | 330 | 29.74 | 29.69 |  | 500 |  |  |  |  |  |  |  | 1394155.107230318
 |  |  |  |  |  |  |  |  |  |  |  |  | 953 | 2023-10-31 00:00:00 | MH27/X-501 | 320 | 28.81 | 28.8 |  | 500 |  |  |  |  |  |  |  | 1350543.318768846
 |  |  |  |  |  |  |  |  |  |  |  |  | 954 | 2023-10-31 00:00:00 | MH40/BL-1604 | 320 | 28.8 | 28.79 |  | 500 |  |  |  |  |  |  |  | 1355283.730558134
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 289.517
CONT NO. 502
DATE. 31.10.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 962 | 2023-11-01 00:00:00 | MH27/X-501 | 330 | 29.69 | 29.66 |  | 502
43 | 2023-10-31 00:00:00 | SOPAN TRADERS | 2796.25 | 4682.73509164059 | 229145 | 11464 | 12051 |  |  |  | 601098 |  | 963 | 2023-11-01 00:00:00 | MH40/BL-1604 | 330 | 29.62 | 29.62 |  | 502
89 | 2023-10-31 00:00:00 | PAYAL TRADERS | 281.38 | 4725.001776956429 | 23267 | 1164 | 1215 |  |  |  | 601101 |  | 966 | 2023-11-01 00:00:00 | MH40/N-5220 | 300 | 26.8 | 26.8 |  | 502
126 | 2023-10-31 00:00:00 | MANASAMATA TRADERS | 166.84 | 4743.328937904579 | 13849 | 693 | 719 |  |  |  | 601100 |  | 967 | 2023-11-01 00:00:00 | MH32/[NAME] | 330 | 29.69 | 29.68 |  | 502
83 | 2023-10-31 00:00:00 | [NAME] | 46.65 | 4696.806002143623 | 3834 | 192 | 201 |  |  |  | 601099 |  | 968 | 2023-11-01 00:00:00 | MH04/EL-9358 | 250 | 22.46 | 22.47 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 969 | 2023-11-01 00:00:00 | MH30/AB-3232 | 280 | 25.17 | 25.17 |  | 502
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 970 | 2023-11-01 00:00:00 | MH28/AB-8385 | 190 | 16.98 | 16.96 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 971 | 2023-11-01 00:00:00 | MH27/BX-6716 | 300 | 26.99 | 26.96 |  | 502
 |  |  | [NAME] | RATE |  |  |  |  |  |  |  |  | 972 | 2023-11-01 00:00:00 | MH27/BQ-4555 | 300 | 26.97 | 26.97 |  | 502 |  |  |  |  | 1251871
 |  |  |  |  |  |  |  |  |  |  |  |  | 961 | 2023-11-01 00:00:00 | MH30/AB-2576 | 28 | 2.462 | 2.462 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 980 | 2023-11-02 00:00:00 | MH30/AB-4249 | 235 | 21.11 | 21.12 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 983 | 2023-11-02 00:00:00 | MP04/HG-9749 | 240 | 21.52 | 21.52 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 981 | 2023-11-02 00:00:00 | MH27/BX-6766 | 304 | 26.66 | 26.66 |  | 502
 |  |  |  |  |  |  |  |  |  |  |  |  | 974 | 2023-11-02 00:00:00 | MH30/AB-2576 | 297 | 26.704 | 26.704 |  | 505
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 329.112
CONT NO. 505
DATE. 01.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 975 | 2023-11-02 00:00:00 | MH40/N-5220 | 350 | 31.43 | 31.43 |  | 505
2739 | 2023-11-01 00:00:00 | BASAPPA GOVINDAPPA BAJARE | 143.83 | 4975.58228464159 | 12524 | 627 | 661 |  |  |  | 601102 |  | 976 | 2023-11-02 00:00:00 | MH28/AB-7013 | 217 | 19.54 | 19.54 |  | 505
80 | 2023-11-01 00:00:00 | SOPAN TRADERS | 1245.54 | 4670.125407453795 | 101793 | 5090 | 5369 |  |  |  |  |  | 977 | 2023-11-02 00:00:00 | MH32/[NAME] | 320 | 28.72 | 28.72 |  | 505
96 | 2023-11-01 00:00:00 | PAYAL TRADERS | 283.12 | 4686.691155693699 | 23221 | 1162 | 1223 |  |  |  |  |  | 978 | 2023-11-02 00:00:00 | MH30/AB-1644 | 280 | 25.22 | 25.21 |  | 505
 |  |  |  |  |  |  |  |  |  |  |  |  | 979 | 2023-11-02 00:00:00 | MH40/BL-1604 | 340 | 30.55 | 30.54 |  | 505
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 981 | 2023-11-02 00:00:00 | MH27/BX-6766 | 49 | 4.25 | 4.25 |  | 505
 |  |  |  |  |  |  |  |  |  |  |  |  | 982 | 2023-11-02 00:00:00 | MH27/BQ-4555 | 280 | 25.13 | 25.12 |  | 505
 |  |  | QTY6 | RATE |  |  |  |  |  |  |  |  | 989 | 2023-11-03 00:00:00 | MH27/X-5988 | 12 | 1.08 | 1.08 |  | 505 |  |  |  |  | 50233
 |  |  |  |  |  |  |  |  |  |  |  |  | 974 | 2023-11-02 00:00:00 | MH30/AB-2576 | 40 | 3.606 | 3.606 |  | 505
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 167.249
CONT NO. 506
DATE. 02.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 989 | 2023-11-03 00:00:00 | MH27/X-5988 | 186 | 16.63 | 16.63 |  | 506
81 | 2023-11-02 00:00:00 | SOPAN TRADERS | 804.86 | 4688.206644633849 | 66034 | 3302 | 3470 |  |  |  | 601105 |  | 984 | 2023-11-03 00:00:00 | MH28/AB-7013 | 217 | 19.53 | 19.52 |  | 506
549 | 2023-11-02 00:00:00 | GOPALDAS SHRIVALLABH LADDHA | 158.57 | 4706.564924008325 | 13061 | 654 | 684 |  |  |  | 601106 |  | 985 | 2023-11-03 00:00:00 | MH30/AB-2576 | 330 | 29.75 | 29.75 |  | 506
943 | 2023-11-02 00:00:00 | HEMANT GOPALDAS DAGA | 160.7 | 4714.617299315495 | 13258 | 663 | 692 |  |  |  | 601107 |  | 986 | 2023-11-03 00:00:00 | MH27/X-501 | 330 | 29.71 | 29.71 |  | 506
128 | 2023-11-02 00:00:00 | MANASAMATA TRADERS | 77.76 | 4725 | 6430 | 322 | 335 |  |  |  | 601108 |  | 987 | 2023-11-03 00:00:00 | MH32/[NAME] | 330 | 29.71 | 29.72 |  | 506
37 | 2023-11-02 00:00:00 | JAI SALASAR TRADERS | 36.33 | 4697.908064960088 | 2987 | 150 | 158 |  |  |  | 601109 |  | 988 | 2023-11-03 00:00:00 | MH40/BL-1604 | 330 | 29.73 | 29.72 |  | 506
2742 | 2023-11-02 00:00:00 | BASAPPA GOVINDAPPA BAJARE | 108.14 | 4712.705751803218 | 8918 | 446 | 465 |  |  |  | 601110
99 | 2023-11-02 00:00:00 | PAYAL TRADERS | 186.17 | 4750.002685717356 | 15475 | 774 | 804 |  |  |  | 601111 |  | BILL PASS |  |  |  |  |  |  |  | 153.253
[NAME]
 |  |  | [NAME] | RATE
CONT NO. 507
DATE. 03.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 990 | 2023-11-04 00:00:00 | MH28/AB-7013 | 217 | 19.53 | 19.51 |  | 507
95 | 2023-11-03 00:00:00 | SOPAN TRADERS | 1537.65 | 4715.500276395798 | 126886 | 6345 | 6626 |  |  |  | 601113 |  | 991 | 2023-11-04 00:00:00 | [NAME]/[NAME] | 270 | 24.31 | 24.28 |  | 507
433 | 2023-11-03 00:00:00 | NILESH MUKUNDRAV DESHMUKH | 9.23 | 4700 | 759 | 38 | 40 |  |  |  | 601112 |  | 993 | 2023-11-04 00:00:00 | MH32/B-7988 | 300 | 26.93 | 26.92 |  | 507
551 | 2023-11-03 00:00:00 | GOPALDAS SHRIVALLABH LADDHA | 34.08 | 4721.919014084508 | 2816 | 141 | 147 |  |  |  | 601114 |  | 994 | 2023-11-04 00:00:00 | MH40/BL-1604 | 330 | 29.7 | 29.67 |  | 507
2750 | 2023-11-03 00:00:00 | BASAPPA GOVINDAPPA BAJARE | 78.28 | 4761.535513541134 | 6523 | 327 | 337 |  |  |  | 601115 |  | 995 | 2023-11-04 00:00:00 | MH27/BX-6808 | 362 | 32.56 | 32.57 |  | 507
5 | 2023-11-03 00:00:00 | PAYAL TRADERS | 193.08 | 4774.994820799668 | 16134 | 807 | 834 |  |  |  | 601116 |  | 996 | 2023-11-04 00:00:00 | MH39/C-1109 | 290 | 26.06 | 26.05 |  | 507
 |  |  |  |  |  |  |  |  |  |  |  |  | 997 | 2023-11-04 00:00:00 | MH28/BB-4879 | 314 | 28.31 | 28.28 |  | 507
[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 185.232
 |  |  | QTY8 | RATE
CONT NO. 510
DATE. 04.11.23
BILL | DATE | NAME OF PARTIES | WEIGHT | RATE | ADAT | TDS | LAVEY | GROSS | BANK/V | BANK/ADAT | CH. |  | MRN.NO. | DATE | TRUCK NO. | [NAME] | DESH.QTY | REC.QTY | [NAME] | CONT-MRN | BAG-QTY | AMRAVATI
NO. |  |  |  |  |  |  |  | AMT |  |  | NO. |  | 998 | 2023-11-05 00:00:00 | MH28/AB-7013 | 217 | 19.54 | 19.54 |  | 510 |  |  |  | 47866.90763611503
2 | 2023-11-04 00:00:00 | SOPAN TRADERS | 1352.68 | 4777.715350267616 | 113097 | 5655 | 5816 |  |  |  | 601117 |  | 999 | 2023-11-05 00:00:00 | MH30/AB-2576 | 332 | 29.81 | 29.79 |  | 510 |  |  |  | 47866.90763611503
130 | 2023-11-04 00:00:00 | MANASAMATA TRADERS | 48.17 | 4800 | 4046 | 203 | 207 |  |  |  | 601118 |  | 1000 | 2023-11-05 00:00:00 | MH27/X-501 | 330 | 29.71 | 29.7 |  | 510 |  |  |  | 47866.90763611503
10 | 2023-11-04 00:00:00 | PAYAL TRADERS | 178.88 | 4820.002236135957 | 15089 | 755 | 773 |  |  |  | 601119 |  | 1002 | 2023-11-05 00:00:00 | MH27/BX-6808 | 276 | 24.84 | 24.8 |  | 510 |  |  |  | 47866.90763611503
 |  |  |  |  |  |  |  |  |  |  |  |  | 1003 | 2023-11-05 00:00:00 | MH40/BL-1604 | 330 | 29.62 | 29.61 |  | 510 |  |  |  | 47866.90763611503
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1004 | 2023-11-05 00:00:00 | MH32/[NAME] | 290 | 26.08 | 26.06 |  | 510 |  |  |  | 47866.90763611503
 |  |  | QTY9 | RATE |  |  |  |  |  |  |  |  | BILL PASS |  |  |  |  |  |  |  | 157.973