Need IF,Vlookup or =INT(MAX whatever can workout number of pleats i will need for what ever measurements i type in for excel so if I type window drop e.g 100 window drop will be the number in between 95 and 125 see chart below the amount of pleats this need is 5 or if I type 150 it should show 6 pleats i will need for this drop see below on this chart 95 is drop and 5 is pleats and 125 is drop 6 is pleats etc i hope some body can help. Thanks for your time to read my post. Window Drop: Pleats needed:
95 5 125 6 156 7 186 8 217 9 247 10 278 11 308 12 339 13 369 14 400 15 430 16 461 17 491 18 522 19 552 20 583 21 613 22 644 23 674 24 705 25 735 26 766 27 796 28 827 29 857 30 888 31 918 32 949 33 979 34 1010 35 1040 36 1071 37 1101 38 1132 39 1162 40 1193 41 1223 42 1254 43 1284 44 1315 45 1345 46 1376 47 1406 48 1437 49 1468 50 1499 51 1539 52 1560 53 1590 54 1621 55 1651 56 1682 57 1712 58 1743 59 1773 60 1804 61 1834 62 1865 63 1895 64 1926 65 1956 66 1987 67 2017 68 2048 69 2078 70 2109 71 2139 72 2170 73 2200 74 2231 75 2261 76 2292 77 2322 78 2353 79 2383 80 2414 81 2444 82 2475 83 2505 84 2536 85 2566 86 2597 87 2627 88 2658 89 2688 90 2719 91 2749 92 2780 93 2810 94 2841 95 2871 96 2902 97 2932 98 2963 99 2993 100 3024 101 3054 102 3085 103 3115 104 3146 105 3176 106 3207 107 3237 108 3268 109 3298 110 3329 111 3359 112 3390 113 3420 114 3451 115 3481 116 3512 117
