Spreadsheet: 144060d1330698702-excel-formula-help-if-then-etc-ainventory
Sheet: Raw Data

Customer number | [NAME] type | Zip code | Amount owed | Date due
Customer 2179 | Sports | 85979 | 882.46 | 2012-03-18 00:00:00
Customer 3744 | Music | 50940 | 664.62 | 2012-03-18 00:00:00
Customer 7502 | Music | 42615 | 605.37 | 2012-05-24 00:00:00
Customer 8219 | Music | 29425 | 644.27 | 2012-05-20 00:00:00
Customer 5190 | Sports | 59792 | 228.92 | 2012-06-18 00:00:00
Customer 5993 | Music | 73066 | 826.32 | 2012-03-02 00:00:00
Customer 5646 | Sports | 77344 | 365.75 | 2012-03-25 00:00:00
Customer 8642 | Music | 64077 | 908.69 | 2012-03-04 00:00:00
Customer 5041 | Theater | 93683 | 884.66 | 2012-07-19 00:00:00
Customer 7252 | Sports | 98068 | 785.73 | 2012-05-11 00:00:00
Customer 2486 | Sports | 75830 | 695.82 | 2012-04-21 00:00:00
Customer 652 | Music | 63239 | 832.27 | 2012-05-19 00:00:00
Customer 5284 | Sports | 22395 | 565.2 | 2012-04-01 00:00:00
Customer 9392 | Theater | 96572 | 100.21 | 2012-07-15 00:00:00
Customer 2381 | Music | 77852 | 684.93 | 2012-03-19 00:00:00
Customer 7360 | Sports | 57674 | 365.41 | 2012-04-20 00:00:00
Customer 4972 | Music | 65102 | 709.86 | 2012-05-09 00:00:00
Customer 975 | Sports | 43636 | 844.17 | 2012-06-25 00:00:00
Customer 792 | Music | 11024 | 191.27 | 2012-07-18 00:00:00
Customer 4726 | Sports | 68312 | 162.06 | 2012-07-28 00:00:00
Customer 9067 | Music | 94887 | 46.12 | 2012-04-20 00:00:00
Customer 2352 | Sports | 62109 | 977.23 | 2012-04-01 00:00:00
Customer 6666 | Sports | 25718 | 667.23 | 2012-05-12 00:00:00
Customer 1218 | Music | 12350 | 796.21 | 2012-05-05 00:00:00
Customer 4659 | Theater | 67960 | 992.48 | 2012-04-07 00:00:00
Customer 6809 | Music | 61979 | 735.73 | 2012-05-20 00:00:00
Customer 108 | Theater | 42859 | 616.33 | 2012-04-22 00:00:00
Customer 1110 | Music | 35603 | 755.48 | 2012-07-06 00:00:00
Customer 5385 | Theater | 16729 | 479.76 | 2012-05-24 00:00:00
Customer 194 | Music | 76022 | 835.44 | 2012-05-24 00:00:00
Customer 9344 | Music | 18068 | 958.11 | 2012-06-28 00:00:00
Customer 3199 | Sports | 19213 | 113.04 | 2012-05-07 00:00:00
Customer 3280 | Theater | 82884 | 971.75 | 2012-07-05 00:00:00
Customer 3136 | Music | 59165 | 388.76 | 2012-07-13 00:00:00
Customer 5431 | Music | 69604 | 1011.89 | 2012-04-24 00:00:00
Customer 897 | Music | 20196 | 491.48 | 2012-03-20 00:00:00
Customer 2647 | Sports | 28389 | 371.12 | 2012-05-09 00:00:00
Customer 9125 | Sports | 65253 | 188.12 | 2012-05-11 00:00:00
Customer 5422 | Sports | 62045 | 732.88 | 2012-03-27 00:00:00
Customer 388 | Music | 56747 | 845.96 | 2012-07-23 00:00:00
Customer 5489 | Music | 41282 | 506.85 | 2012-03-07 00:00:00
Customer 1089 | Music | 16887 | 742.24 | 2012-04-01 00:00:00
Customer 8380 | Music | 66298 | 644.69 | 2012-06-19 00:00:00
Customer 7136 | Sports | 44869 | 936.28 | 2012-06-29 00:00:00
Customer 1352 | Music | 16091 | 279.94 | 2012-06-01 00:00:00
Customer 3381 | Sports | 80609 | 461.23 | 2012-03-26 00:00:00
Customer 8163 | Sports | 64303 | 191.76 | 2012-07-01 00:00:00
Customer 1184 | Theater | 35870 | 544.35 | 2012-05-02 00:00:00
Customer 9693 | Music | 41821 | 557.5 | 2012-07-10 00:00:00
Customer 8442 | Theater | 52602 | 96.58 | 2012-07-24 00:00:00
Customer 1781 | Theater | 82491 | 294.7 | 2012-07-05 00:00:00
Customer 5578 | Theater | 86956 | 512.51 | 2012-06-17 00:00:00
Customer 4084 | Music | 71845 | 358.55 | 2012-04-30 00:00:00
Customer 7823 | Theater | 97016 | 1001.49 | 2012-03-11 00:00:00
Customer 3445 | Theater | 34368 | 259.96 | 2012-05-29 00:00:00
Customer 9498 | Theater | 10885 | 882.12 | 2012-06-30 00:00:00
Customer 5404 | Sports | 27969 | 134.89 | 2012-06-07 00:00:00
Customer 9655 | Theater | 87438 | 481.01 | 2012-04-03 00:00:00
Customer 5034 | Music | 15688 | 289.04 | 2012-07-08 00:00:00
Customer 9648 | Sports | 21166 | 888.82 | 2012-06-21 00:00:00
Customer 9404 | Theater | 35979 | 699.02 | 2012-05-10 00:00:00
Customer 3231 | Theater | 25304 | 111.77 | 2012-07-09 00:00:00
Customer 7712 | Theater | 75107 | 493.46 | 2012-04-06 00:00:00
Customer 8405 | Music | 41853 | 898.58 | 2012-07-27 00:00:00
Customer 2760 | Theater | 57719 | 1007.44 | 2012-04-01 00:00:00
Customer 3983 | Music | 69443 | 703.01 | 2012-03-19 00:00:00
Customer 4102 | Music | 64174 | 150.01 | 2012-04-25 00:00:00
Customer 9175 | Theater | 34805 | 863.64 | 2012-04-05 00:00:00
Customer 1073 | Music | 97664 | 900.28 | 2012-06-12 00:00:00
Customer 8571 | Sports | 24834 | 675.85 | 2012-05-07 00:00:00
Customer 7313 | Sports | 23288 | 549.39 | 2012-03-16 00:00:00
Customer 789 | Theater | 15228 | 872.84 | 2012-06-23 00:00:00
Customer 3274 | Theater | 89037 | 436.67 | 2012-06-17 00:00:00
Customer 3112 | Music | 89847 | 788.52 | 2012-06-27 00:00:00
Customer 3844 | Theater | 60752 | 374.67 | 2012-05-03 00:00:00
Customer 6940 | Sports | 77131 | 934.38 | 2012-05-04 00:00:00
Customer 5273 | Music | 86906 | 168.46 | 2012-05-14 00:00:00
Customer 3016 | Music | 71998 | 948.3 | 2012-05-08 00:00:00
Customer 2488 | Music | 50551 | 810.82 | 2012-07-18 00:00:00
Customer 1508 | Music | 39311 | 102.12 | 2012-07-28 00:00:00
Customer 7977 | Theater | 70170 | 564.81 | 2012-04-12 00:00:00
Customer 228 | Theater | 98385 | 410.68 | 2012-05-24 00:00:00
Customer 3559 | Theater | 89390 | 403.92 | 2012-07-17 00:00:00
Customer 1903 | Sports | 76266 | 572.32 | 2012-06-16 00:00:00
Customer 1366 | Theater | 54393 | 574.66 | 2012-04-22 00:00:00
Customer 4324 | Theater | 81125 | 546.95 | 2012-05-29 00:00:00
Customer 889 | Music | 25959 | 57.23 | 2012-07-02 00:00:00
Customer 9343 | Music | 26060 | 875.83 | 2012-06-30 00:00:00
Customer 8053 | Theater | 53251 | 717.9 | 2012-06-22 00:00:00
Customer 5477 | Theater | 30895 | 546.05 | 2012-04-08 00:00:00
Customer 6012 | Sports | 32826 | 732.7 | 2012-04-17 00:00:00
Customer 6612 | Theater | 50700 | 155.78 | 2012-05-26 00:00:00
Customer 2224 | Sports | 81961 | 583.07 | 2012-06-27 00:00:00
Customer 9034 | Music | 28690 | 281.24 | 2012-03-18 00:00:00
Customer 2509 | Sports | 90170 | 879.96 | 2012-06-18 00:00:00
Customer 459 | Music | 12589 | 375.33 | 2012-06-17 00:00:00
Customer 5991 | Theater | 57557 | 302.74 | 2012-07-27 00:00:00
Customer 7669 | Sports | 17547 | 614.95 | 2012-04-24 00:00:00
Customer 5356 | Sports | 26146 | 37 | 2012-03-25 00:00:00
Customer 9634 | Theater | 55023 | 123.16 | 2012-07-04 00:00:00
Customer 6041 | Sports | 24745 | 730.08 | 2012-05-25 00:00:00
Customer 6332 | Music | 45865 | 155.08 | 2012-07-19 00:00:00
Customer 2195 | Music | 51011 | 934.89 | 2012-03-14 00:00:00
Customer 5030 | Music | 31079 | 70.82 | 2012-05-10 00:00:00
Customer 3541 | Theater | 15282 | 520.66 | 2012-03-05 00:00:00
Customer 9282 | Theater | 40562 | 233.69 | 2012-03-15 00:00:00
Customer 2786 | Theater | 38592 | 78.6 | 2012-05-20 00:00:00
Customer 2406 | Sports | 14254 | 490.28 | 2012-04-03 00:00:00
Customer 7974 | Sports | 41987 | 420.58 | 2012-07-15 00:00:00
Customer 2040 | Music | 58790 | 141.6 | 2012-04-14 00:00:00
Customer 4945 | Music | 19233 | 624.93 | 2012-03-14 00:00:00
Customer 8572 | Sports | 25129 | 848.44 | 2012-05-11 00:00:00
Customer 2440 | Sports | 98772 | 764.66 | 2012-04-01 00:00:00
Customer 2652 | Music | 20329 | 942.1 | 2012-06-04 00:00:00
Customer 5482 | Sports | 68155 | 975.81 | 2012-06-02 00:00:00
Customer 2722 | Sports | 85115 | 972.55 | 2012-04-01 00:00:00
Customer 1847 | Music | 64953 | 274.6 | 2012-03-17 00:00:00
Customer 5586 | Music | 55118 | 704.53 | 2012-05-27 00:00:00
Customer 1157 | Music | 55710 | 505.67 | 2012-04-09 00:00:00
Customer 833 | Theater | 67648 | 605.56 | 2012-07-23 00:00:00
Customer 9878 | Music | 97815 | 34.21 | 2012-05-25 00:00:00
Customer 7473 | Theater | 47762 | 394.07 | 2012-04-10 00:00:00
Customer 3126 | Sports | 40109 | 923.67 | 2012-04-19 00:00:00
Customer 8848 | Music | 81484 | 44.42 | 2012-03-07 00:00:00
Customer 1970 | Music | 86386 | 557.84 | 2012-05-09 00:00:00
Customer 5809 | Sports | 50339 | 337.73 | 2012-03-16 00:00:00
Customer 5582 | Sports | 54425 | 615.23 | 2012-06-13 00:00:00
Customer 9513 | Music | 79218 | 650.3 | 2012-04-23 00:00:00
Customer 4589 | Music | 52342 | 894.78 | 2012-03-30 00:00:00
Customer 9572 | Music | 64220 | 501.4 | 2012-06-06 00:00:00
Customer 3770 | Music | 63387 | 877.74 | 2012-07-12 00:00:00
Customer 7308 | Theater | 70902 | 346.18 | 2012-06-29 00:00:00
Customer 610 | Sports | 84682 | 755.6 | 2012-06-11 00:00:00
Customer 5596 | Music | 41767 | 306.6 | 2012-04-27 00:00:00
Customer 6301 | Sports | 83394 | 57.73 | 2012-03-09 00:00:00
Customer 1960 | Theater | 84552 | 622.41 | 2012-03-16 00:00:00
Customer 1146 | Music | 21057 | 76.74 | 2012-07-20 00:00:00
Customer 9496 | Music | 67411 | 951.57 | 2012-04-03 00:00:00
Customer 8561 | Theater | 76763 | 399.8 | 2012-06-26 00:00:00
Customer 9150 | Music | 74155 | 760.77 | 2012-07-06 00:00:00
Customer 2001 | Theater | 27658 | 593.36 | 2012-06-02 00:00:00
Customer 2539 | Music | 15841 | 848.08 | 2012-04-06 00:00:00
Customer 4394 | Sports | 28447 | 500.36 | 2012-07-16 00:00:00
Customer 4996 | Music | 10474 | 961.3 | 2012-04-09 00:00:00
Customer 4815 | Music | 42487 | 245.05 | 2012-06-17 00:00:00
Customer 4885 | Theater | 24408 | 1005.3 | 2012-03-11 00:00:00
Customer 5440 | Theater | 72609 | 691.54 | 2012-06-11 00:00:00
Customer 9717 | Music | 83457 | 589.6 | 2012-07-09 00:00:00
Customer 4766 | Music | 84632 | 161.59 | 2012-07-08 00:00:00
Customer 3303 | Theater | 82172 | 837.85 | 2012-05-09 00:00:00
Customer 4870 | Theater | 35228 | 569.06 | 2012-05-06 00:00:00
Customer 7691 | Music | 90563 | 852.51 | 2012-07-28 00:00:00
Customer 9942 | Sports | 35335 | 843.45 | 2012-04-21 00:00:00
Customer 6882 | Sports | 50212 | 821.09 | 2012-06-21 00:00:00
Customer 5852 | Sports | 33255 | 772.87 | 2012-05-10 00:00:00
Customer 6451 | Sports | 97732 | 858.32 | 2012-05-22 00:00:00
Customer 9070 | Music | 87215 | 448.3 | 2012-03-23 00:00:00
Customer 3061 | Music | 47419 | 330.42 | 2012-03-13 00:00:00
Customer 7056 | Music | 85761 | 769.38 | 2012-06-29 00:00:00
Customer 6524 | Theater | 30331 | 580.71 | 2012-04-16 00:00:00
Customer 7572 | Sports | 39880 | 914.63 | 2012-07-09 00:00:00
Customer 4733 | Theater | 92023 | 122.2 | 2012-06-06 00:00:00
Customer 284 | Sports | 10110 | 93.11 | 2012-04-22 00:00:00
Customer 6751 | Theater | 40893 | 713.87 | 2012-04-25 00:00:00
Customer 1525 | Sports | 13107 | 973.04 | 2012-07-26 00:00:00
Customer 3712 | Music | 34287 | 142.38 | 2012-05-16 00:00:00
Customer 66 | Sports | 51749 | 390.64 | 2012-06-17 00:00:00
Customer 1170 | Sports | 52533 | 926.83 | 2012-03-24 00:00:00
Customer 9132 | Theater | 54899 | 451.72 | 2012-03-13 00:00:00
Customer 5655 | Sports | 58394 | 119.03 | 2012-04-25 00:00:00
Customer 5284 | Sports | 45131 | 137.85 | 2012-06-24 00:00:00
Customer 2599 | Music | 92883 | 713.98 | 2012-05-22 00:00:00
Customer 8917 | Music | 62490 | 22.11 | 2012-05-05 00:00:00
Customer 4497 | Music | 49449 | 80.17 | 2012-04-09 00:00:00
Customer 2647 | Theater | 54178 | 477.7 | 2012-06-12 00:00:00
Customer 3681 | Music | 68759 | 32.56 | 2012-03-26 00:00:00
Customer 3097 | Music | 59569 | 97.32 | 2012-07-10 00:00:00
Customer 7303 | Sports | 77739 | 528.32 | 2012-07-09 00:00:00
Customer 1324 | Sports | 45436 | 923.52 | 2012-06-02 00:00:00
Customer 4514 | Music | 96421 | 884.26 | 2012-04-05 00:00:00
Customer 8931 | Sports | 33503 | 366.98 | 2012-07-03 00:00:00
Customer 2897 | Music | 73665 | 441.33 | 2012-05-07 00:00:00
Customer 9198 | Music | 27608 | 592.09 | 2012-05-14 00:00:00
Customer 3795 | Sports | 92252 | 988.02 | 2012-06-28 00:00:00
Customer 6026 | Theater | 24596 | 248.36 | 2012-03-11 00:00:00
Customer 8690 | Music | 91653 | 118.3 | 2012-07-22 00:00:00
Customer 3823 | Theater | 32778 | 612.11 | 2012-05-27 00:00:00
Customer 3123 | Music | 25449 | 632.26 | 2012-06-11 00:00:00
Customer 4347 | Music | 91892 | 740.8 | 2012-06-01 00:00:00
Customer 2283 | Music | 47762 | 425.97 | 2012-05-17 00:00:00
Customer 4753 | Sports | 48683 | 771.49 | 2012-06-18 00:00:00
Customer 5998 | Theater | 84046 | 151.86 | 2012-04-04 00:00:00
Customer 3761 | Music | 49067 | 454.22 | 2012-06-03 00:00:00
Customer 2386 | Sports | 37879 | 768.7 | 2012-07-06 00:00:00
Customer 7785 | Theater | 85887 | 173.1 | 2012-04-26 00:00:00
Customer 8490 | Theater | 29892 | 161.4 | 2012-03-31 00:00:00
Customer 6502 | Music | 38959 | 126.83 | 2012-04-23 00:00:00
Customer 6044 | Sports | 36432 | 373.37 | 2012-07-23 00:00:00
Customer 3846 | Music | 21136 | 298.87 | 2012-07-09 00:00:00
Customer 5562 | Music | 76944 | 249.92 | 2012-05-30 00:00:00
Customer 1638 | Sports | 71758 | 406.15 | 2012-06-05 00:00:00
Customer 3671 | Music | 78985 | 763.73 | 2012-06-27 00:00:00
Customer 1031 | Sports | 83696 | 835.3 | 2012-05-28 00:00:00
Customer 7029 | Theater | 71686 | 292.81 | 2012-03-22 00:00:00
Customer 9511 | Music | 51559 | 961.55 | 2012-07-07 00:00:00
Customer 7384 | Sports | 18554 | 252.49 | 2012-05-19 00:00:00
Customer 6504 | Theater | 56743 | 223.68 | 2012-04-12 00:00:00
Customer 6496 | Sports | 80305 | 456.23 | 2012-03-12 00:00:00
Customer 3848 | Music | 12293 | 635.85 | 2012-07-06 00:00:00
Customer 7580 | Sports | 68592 | 735.48 | 2012-04-27 00:00:00
Customer 7866 | Sports | 56915 | 217.37 | 2012-06-25 00:00:00
Customer 1869 | Music | 69199 | 33.45 | 2012-05-25 00:00:00
Customer 4929 | Theater | 58361 | 409.62 | 2012-07-02 00:00:00
Customer 1312 | Theater | 52046 | 581.76 | 2012-03-03 00:00:00
Customer 1820 | Theater | 59946 | 705.62 | 2012-05-26 00:00:00
Customer 4748 | Sports | 74807 | 666.23 | 2012-07-10 00:00:00
Customer 9904 | Sports | 21031 | 785.74 | 2012-06-11 00:00:00
Customer 556 | Sports | 32133 | 930.39 | 2012-04-14 00:00:00
Customer 99 | Theater | 67301 | 943.99 | 2012-04-22 00:00:00
Customer 6400 | Music | 92368 | 70.6 | 2012-04-18 00:00:00
Customer 3251 | Music | 48827 | 240.05 | 2012-03-22 00:00:00
Customer 3790 | Sports | 11680 | 899.94 | 2012-04-04 00:00:00
Customer 5543 | Music | 92953 | 561.19 | 2012-04-22 00:00:00
Customer 9505 | Music | 73188 | 246.54 | 2012-03-31 00:00:00
Customer 3379 | Music | 54246 | 850.2 | 2012-04-05 00:00:00
Customer 5232 | Music | 75804 | 156.36 | 2012-03-24 00:00:00
Customer 520 | Music | 19290 | 921.28 | 2012-04-06 00:00:00
Customer 415 | Theater | 95840 | 880.6 | 2012-06-26 00:00:00
Customer 3814 | Music | 96022 | 789.06 | 2012-04-23 00:00:00
Customer 9351 | Theater | 49029 | 471.48 | 2012-06-14 00:00:00
Customer 8137 | Music | 18960 | 761.31 | 2012-04-14 00:00:00
Customer 3055 | Sports | 90025 | 363.61 | 2012-05-18 00:00:00
Customer 2489 | Sports | 88910 | 663.49 | 2012-03-12 00:00:00
Customer 1681 | Theater | 62268 | 611.07 | 2012-06-13 00:00:00
Customer 9190 | Theater | 78786 | 124.17 | 2012-04-20 00:00:00
Customer 9340 | Sports | 80605 | 849.49 | 2012-05-26 00:00:00
Customer 5488 | Sports | 18498 | 891.8 | 2012-06-11 00:00:00
Customer 4544 | Theater | 14076 | 577.25 | 2012-04-07 00:00:00
Customer 9623 | Sports | 73722 | 561.2 | 2012-05-20 00:00:00
Customer 2158 | Theater | 50825 | 700.04 | 2012-07-19 00:00:00
Customer 3299 | Theater | 34581 | 907.08 | 2012-03-08 00:00:00
Customer 3757 | Music | 45594 | 884.16 | 2012-07-01 00:00:00
Customer 178 | Sports | 96501 | 416.2 | 2012-04-03 00:00:00
Customer 9463 | Music | 30941 | 292.48 | 2012-07-25 00:00:00
Customer 8281 | Theater | 44183 | 539.53 | 2012-04-03 00:00:00
Customer 7957 | Theater | 53739 | 593.45 | 2012-05-17 00:00:00
Customer 3357 | Music | 39102 | 686.18 | 2012-05-31 00:00:00
Customer 7092 | Theater | 28636 | 341.62 | 2012-07-11 00:00:00
Customer 8840 | Music | 16480 | 645.02 | 2012-07-24 00:00:00
Customer 3946 | Music | 11577 | 312.89 | 2012-07-12 00:00:00
Customer 6764 | Sports | 66824 | 130.52 | 2012-03-07 00:00:00