Spreadsheet: 677619d1589438493-need-a-help-in-and-function-of-and-and-if-function-pp
Sheet: Sheet3

symbol | ltP | S3 | S2 | S1 | PP | R1 | R2 | R3 | BL S3 | BL S2 | BL S1 | BL PP | AB PP | AB R1 | AB R2 | AB R3
ADANIPOWER | 33.95 | 27.4 | 28.65 | 30.25 | 31.5 | 33.1 | 34.35 | 35.95
BHEL | 28.25 | 18.45 | 20.3 | 23.45 | 25.3 | 28.45 | 30.3 | 33.45 |  |  |  |  |  |  |  |  | My problem
INFRATEL | 206.75 | 184.69 | 188.12 | 192.14 | 195.57 | 199.59 | 203.02 | 207.04 |  |  |  |  |  |  |  |  | When Cell value in B2(ltP)between the cell value in C2  & D2(C2>B2<D2) IN COLUMN K2 I SHOULD GET TRUE AND WHEN  Cell value in B2(ltP)between the cell value in D2  & E2 IN COLUMN L2 I SHOULD GET TRUE AND Cell value in B2(ltP)between the cell value in E2  & F2 IN COLUMN M2 I SHOULD GET TRUE WISE VERSA FOR ALL COLUMN AND ALL ROWS.Already i tried with AND function and combination of IF & AND function,both is failing and i do not know where i am doing the mistake.
TATAPOWER | 31.85 | 26.95 | 27.9 | 29.1 | 30.05 | 31.25 | 32.2 | 33.4
GODREJCP | 559.75 | 501.5 | 512.25 | 523.35 | 534.1 | 545.2 | 555.95 | 567.0500000000001
[NAME] | 340.00 | 313.46 | 317.28 | 321.11 | 324.93 | 328.76 | 332.58 | 336.41
MCDOWELL-N | 531.45 | 472.29 | 488.67 | 499.4400000000001 | 515.82 | 526.5900000000001 | 542.97 | 553.7400000000001
DABUR | 460.25 | 421.99 | 432.22 | 438.14 | 448.37 | 454.29 | 464.52 | 470.4400000000001
GLENMARK | 348.15 | 326.15 | 330.35 | 333.6 | 337.8 | 341.05 | 345.25 | 348.5
EQUITAS | 53.70 | 47.05 | 48.35 | 50.3 | 51.6 | 53.55 | 54.85 | 56.8
BAJFINANCE | 2,217.80 | 2029.1 | 2087.05 | 2124.05 | 2182 | 2219 | 2276.95 | 2313.95
MARICO | 314.95 | 298.75 | 302 | 304.5 | 307.75 | 310.25 | 313.5 | 316
COLPAL | 1,355.60 | 1256.86 | 1287.83 | 1305.86 | 1336.83 | 1354.86 | 1385.83 | 1403.86
JUSTDIAL | 359.00 | 334.51 | 341.63 | 346.66 | 353.78 | 358.8099999999999 | 365.9299999999999 | 370.9599999999999
NAUKRI | 2,669.15 | 2502.44 | 2538.72 | 2577.44 | 2613.72 | 2652.44 | 2688.72 | 2727.44
TORNTPOWER | 311.20 | 279.41 | 290.03 | 297.56 | 308.18 | 315.71 | 326.33 | 333.8600000000001
FEDERALBNK | 44.00 | 39.19 | 40.72 | 41.94 | 43.47 | 44.69 | 46.22 | 47.44
NESTLEIND | 16,798.00 | 14674.9 | 15537.45 | 16024.9 | 16887.45 | 17374.9 | 18237.45 | 18724.9
UBL | 930.70 | 863.5 | 881.75 | 898.5 | 916.75 | 933.5 | 951.75 | 968.5
[NAME] | 853.30 | 800.8400000000001 | 818.0200000000001 | 828.6400000000001 | 845.82 | 856.44 | 873.62 | 884.24
APOLLOHOSP | 1,305.50 | 1174.36 | 1216.18 | 1250.36 | 1292.18 | 1326.36 | 1368.18 | 1402.36
BALKRISIND | 954.00 | 907.6999999999999 | 918.9 | 928.8 | 940 | 949.9 | 961.1 | 971
CONCOR | 386.50 | 349.96 | 357.48 | 368.96 | 376.48 | 387.96 | 395.48 | 406.96
BRITANNIA | 3,127.90 | 2898.2 | 2977.85 | 3028.7 | 3108.35 | 3159.2 | 3238.85 | 3289.7
CESC | 603.50 | 548.06 | 569.53 | 581.9599999999999 | 603.43 | 615.8599999999999 | 637.3299999999999 | 649.7599999999999
MANAPPURAM | 123.15 | 113.66 | 116.58 | 118.96 | 121.88 | 124.26 | 127.18 | 129.56
SRF | 3,652.60 | 3432.909999999999 | 3513.13 | 3559.46 | 3639.68 | 3686.01 | 3766.23 | 3812.56
SUNPHARMA | 458.25 | 425.96 | 438.08 | 445.21 | 457.33 | 464.46 | 476.58 | 483.71
IBULHSGFIN | 138.35 | 113.79 | 119.57 | 128.09 | 133.87 | 142.39 | 148.17 | 156.69
PETRONET | 235.00 | 219.19 | 224.92 | 228.49 | 234.22 | 237.79 | 243.52 | 247.09
DIVISLAB | 2,368.35 | 2220.46 | 2267.23 | 2303.36 | 2350.13 | 2386.26 | 2433.03 | 2469.16
PEL | 897.75 | 785.6400000000001 | 833.4200000000001 | 860.24 | 908.02 | 934.8399999999999 | 982.6199999999999 | 1009.44
HINDUNILVR | 2,019.65 | 1856.16 | 1915.78 | 1955.76 | 2015.38 | 2055.36 | 2114.98 | 2154.96
TATACONSUM | 360.00 | 318.4 | 333.45 | 344.9 | 359.95 | 371.4 | 386.45 | 397.9
BIOCON | 340.60 | 311.1999999999999 | 322.65 | 329.9499999999999 | 341.4 | 348.6999999999999 | 360.15 | 367.4499999999999
[NAME] | 818.60 | 761.54 | 784.77 | 798.54 | 821.77 | 835.54 | 858.77 | 872.54
BAJAJFINSV | 4,853.10 | 4441.1 | 4609.6 | 4713 | 4881.5 | 4984.9 | 5153.4 | 5256.799999999999
NATIONALUM | 28.45 | 25.69 | 26.62 | 27.44 | 28.37 | 29.19 | 30.12 | 30.94
NCC | 24.30 | 20.74000000000001 | 22.02 | 23.09 | 24.37 | 25.44 | 26.72 | 27.79
HEROMOTOCO | 2,200.85 | 2018.4 | 2083.2 | 2135.4 | 2200.2 | 2252.4 | 2317.2 | 2369.4
DRREDDY | 3,800.20 | 3612.9 | 3674 | 3726.8 | 3787.9 | 3840.7 | 3901.8 | 3954.6
TORNTPHARM | 2,417.15 | 2198.1 | 2278.05 | 2341.1 | 2421.05 | 2484.1 | 2564.05 | 2627.1
UJJIVAN | 176.00 | 160.74 | 166.37 | 170.74 | 176.37 | 180.74 | 186.37 | 190.74
MGL | 925.70 | 881.7 | 892.5 | 907.3000000000001 | 918.1 | 932.9000000000001 | 943.7 | 958.5000000000001
CIPLA | 572.00 | 521.64 | 545.27 | 557.74 | 581.37 | 593.84 | 617.47 | 629.94
PAGEIND | 17,545.00 | 16837.65 | 17083.85 | 17290.85 | 17537.05 | 17744.05 | 17990.25 | 18197.25
MARUTI | 5,043.50 | 4577.890000000001 | 4782.070000000001 | 4909.090000000001 | 5113.27 | 5240.290000000001 | 5444.47 | 5571.490000000001
VOLTAS | 464.80 | 421.8599999999999 | 437.3799999999999 | 450.7599999999999 | 466.28 | 479.66 | 495.18 | 508.56
VEDL | 90.30 | 77.06 | 82.78 | 86.51 | 92.23 | 95.96000000000001 | 101.68 | 105.41
GMRINFRA | 18.10 | 16.96 | 17.33 | 17.71 | 18.08 | 18.46 | 18.83 | 19.21
KOTAKBANK | 1,186.40 | 1118.96 | 1145.83 | 1166.26 | 1193.13 | 1213.56 | 1240.43 | 1260.86
AUROPHARMA | 675.45 | 630.01 | 649.23 | 662.56 | 681.78 | 695.1099999999999 | 714.3299999999999 | 727.6599999999999
MFSL | 449.80 | 423.2499999999999 | 433.15 | 441.8 | 451.7 | 460.35 | 470.25 | 478.9
RBLBANK | 121.30 | 110.6 | 114.9 | 118.2 | 122.5 | 125.8 | 130.1 | 133.4
ADANIPORTS | 308.85 | 227.61 | 244.98 | 277.16 | 294.53 | 326.7099999999999 | 344.0799999999999 | 376.2599999999999
M%26MFIN | 176.50 | 153.81 | 159.08 | 167.96 | 173.23 | 182.11 | 187.38 | 196.26
ASHOKLEY | 48.65 | 43.41 | 45.78 | 47.26000000000001 | 49.63 | 51.11000000000001 | 53.48 | 54.96000000000001
UPL | 388.80 | 362.36 | 371.48 | 380.56 | 389.68 | 398.76 | 407.88 | 416.96
RAMCOCEM | 553.65 | 510.8900000000001 | 521.6700000000001 | 538.44 | 549.22 | 565.99 | 576.77 | 593.54
ITC | 164.80 | 152.96 | 158.73 | 162.06 | 167.83 | 171.16 | 176.93 | 180.26
BAJAJ-AUTO | 2,685.90 | 2550.91 | 2611.13 | 2653.56 | 2713.78 | 2756.21 | 2816.43 | 2858.860000000001
BOSCHLTD | 9,744.00 | 9209 | 9420.5 | 9605.9 | 9817.4 | 10002.8 | 10214.3 | 10399.7
JUBLFOOD | 1,689.45 | 1521.64 | 1571.32 | 1635.19 | 1684.87 | 1748.74 | 1798.42 | 1862.29
SBILIFE | 756.10 | 721.9100000000001 | 737.4300000000001 | 748.96 | 764.48 | 776.01 | 791.53 | 803.06
RECLTD | 99.95 | 83.56 | 87.73 | 94.16 | 98.33 | 104.76 | 108.93 | 115.36
SRTRANSFIN | 667.20 | 589.84 | 626.72 | 649.19 | 686.07 | 708.5400000000001 | 745.4200000000001 | 767.8900000000001
HCLTECH | 525.25 | 501.9499999999998 | 511.7499999999999 | 520.2499999999999 | 530.05 | 538.55 | 548.35 | 556.85
IOC | 75.50 | 73.04999999999998 | 74.39999999999999 | 75.19999999999999 | 76.55 | 77.35 | 78.7 | 79.5
BATAINDIA | 1,374.15 | 1280.74 | 1304.47 | 1344.54 | 1368.27 | 1408.34 | 1432.07 | 1472.14
IGL | 469.45 | 445.66 | 457.53 | 465.26 | 477.13 | 484.86 | 496.73 | 504.46
CUMMINSIND | 359.30 | 344.15 | 352.65 | 357.65 | 366.15 | 371.15 | 379.65 | 384.65
TVSMOTOR | 341.70 | 320.01 | 331.03 | 337.96 | 348.98 | 355.91 | 366.93 | 373.86
TITAN | 852.00 | 821.6999999999998 | 838.8499999999999 | 849.6499999999999 | 866.8 | 877.5999999999999 | 894.75 | 905.55
HINDPETRO | 190.40 | 181.51 | 185.53 | 188.91 | 192.93 | 196.31 | 200.33 | 203.71
[NAME] | 151.35 | 141.85 | 146.7 | 149.8 | 154.65 | 157.75 | 162.6 | 165.7
CENTURYTEX | 276.25 | 254.75 | 262.5 | 270.8 | 278.55 | 286.85 | 294.6 | 302.9
ADANIENT | 139.50 | 135.35 | 138.05 | 139.6 | 142.3 | 143.85 | 146.55 | 148.1
ULTRACEMCO | 3,505.00 | 3341.14 | 3395.57 | 3471.14 | 3525.57 | 3601.14 | 3655.57 | 3731.14
BERGEPAINT | 449.60 | 422.66 | 435.53 | 445.26 | 458.13 | 467.86 | 480.73 | 490.46
SUNTV | 386.70 | 357.6 | 373.8 | 382.6 | 398.8 | 407.6 | 423.8 | 432.6
AMBUJACEM | 180.80 | 170.66 | 176.33 | 179.66 | 185.33 | 188.66 | 194.33 | 197.66
GODREJPROP | 651.90 | 586.56 | 604.28 | 632.16 | 649.88 | 677.76 | 695.48 | 723.36
BHARTIARTL | 548.65 | 526.46 | 537.88 | 546.9100000000001 | 558.33 | 567.3600000000001 | 578.7800000000001 | 587.8100000000002
SHREECEM | 19,500.00 | 18499.65 | 18971.05 | 19367.15 | 19838.55 | 20234.65 | 20706.05 | 21102.15
BANKBARODA | 43.55 | 39.56 | 40.88 | 42.51 | 43.83 | 45.45999999999999 | 46.77999999999999 | 48.40999999999999
PFC | 88.40 | 77.99999999999999 | 81.35 | 85.49999999999999 | 88.85 | 92.99999999999999 | 96.35 | 100.5
MRF | 58,810.00 | 56532.60000000001 | 57377.05 | 58511.10000000001 | 59355.55 | 60489.60000000001 | 61334.05 | 62468.10000000001
SIEMENS | 1,030.00 | 988.8400000000001 | 1006.92 | 1025.84 | 1043.92 | 1062.84 | 1080.92 | 1099.84
APOLLOTYRE | 93.05 | 87.85 | 90 | 92.19999999999999 | 94.35 | 96.54999999999998 | 98.69999999999999 | 100.9
EICHERMOT | 14,064.00 | 13195.6 | 13690.15 | 13980.9 | 14475.45 | 14766.2 | 15260.75 | 15551.5
CANBK | 87.70 | 74.95 | 78.25 | 83.65 | 86.95 | 92.35000000000001 | 95.65 | 101.05
YESBANK | 28.20 | 26.66 | 27.38 | 28.01 | 28.73 | 29.36 | 30.08 | 30.71
COALINDIA | 128.55 | 124.56 | 126.53 | 128.56 | 130.53 | 132.56 | 134.53 | 136.56
PNB | 30.10 | 28.15 | 28.8 | 29.7 | 30.35 | 31.25 | 31.9 | 32.8
BPCL | 311.25 | 299.75 | 306.25 | 311.4 | 317.9 | 323.05 | 329.55 | 334.6999999999999
SAIL | 28.25 | 27.06 | 27.68 | 28.21 | 28.83 | 29.36 | 29.98 | 30.50999999999999
WIPRO | 186.40 | 179.71 | 182.43 | 186.06 | 188.78 | 192.41 | 195.13 | 198.76
JINDALSTEL | 95.65 | 82.60999999999999 | 86.97999999999999 | 92.16 | 96.53 | 101.71 | 106.08 | 111.26
BANDHANBNK | 247.75 | 230.71 | 237.03 | 244.61 | 250.93 | 258.51 | 264.83 | 272.41
TATACHEM | 294.30 | 277.41 | 284.38 | 292.0599999999999 | 299.03 | 306.7099999999999 | 313.6799999999999 | 321.3599999999999
ACC | 1,184.95 | 1121.39 | 1158.32 | 1183.14 | 1220.07 | 1244.89 | 1281.82 | 1306.64
PIDILITIND | 1,358.95 | 1326.99 | 1344.52 | 1364.94 | 1382.47 | 1402.89 | 1420.42 | 1440.84
AXISBANK | 406.05 | 386.74 | 393.17 | 403.59 | 410.02 | 420.4399999999999 | 426.8699999999999 | 437.2899999999999
[NAME] | 557.80 | 542.76 | 553.23 | 561.06 | 571.53 | 579.3599999999999 | 589.8299999999999 | 597.6599999999999
RELIANCE | 1,466.80 | 1384.96 | 1419.48 | 1457.96 | 1492.48 | 1530.96 | 1565.48 | 1603.96
PVR | 902.60 | 848.6000000000001 | 867.3000000000001 | 894.2500000000001 | 912.95 | 939.9000000000001 | 958.6 | 985.5500000000001
L%26TFH | 60.60 | 54.8 | 56.65 | 59.25 | 61.1 | 63.7 | 65.55000000000001 | 68.15
TATASTEEL | 270.75 | 256.2 | 264.85 | 270.7 | 279.35 | 285.2 | 293.85 | 299.7
GRASIM | 511.75 | 480.3899999999999 | 499.7199999999999 | 511.3399999999999 | 530.67 | 542.29 | 561.62 | 573.24
LT | 844.15 | 830.1599999999999 | 840.3299999999999 | 851.6099999999999 | 861.78 | 873.06 | 883.23 | 894.51
ICICIPRULI | 387.30 | 372.9 | 383.45 | 389.9 | 400.45 | 406.9 | 417.45 | 423.9
ESCORTS | 793.15 | 713.86 | 737.98 | 775.11 | 799.23 | 836.36 | 860.48 | 897.61
BHARATFORG | 278.50 | 257.3099999999999 | 270.1299999999999 | 277.7099999999999 | 290.53 | 298.11 | 310.93 | 318.51
NMDC | 73.10 | 68.44 | 70.42 | 72.69 | 74.67 | 76.94 | 78.92 | 81.19
MOTHERSUMI | 82.25 | 78.66000000000001 | 81.18 | 82.76 | 85.28 | 86.86 | 89.38 | 90.96
TCS | 1,899.90 | 1850.51 | 1888.08 | 1918.86 | 1956.43 | 1987.21 | 2024.78 | 2055.56
ONGC | 76.15 | 73.81 | 75.03 | 76.61 | 77.83 | 79.41 | 80.63 | 82.21
SBIN | 169.30 | 162.16 | 166.33 | 170.21 | 174.38 | 178.26 | 182.43 | 186.31
ASIANPAINT | 1,519.15 | 1491.39 | 1512.37 | 1537.84 | 1558.82 | 1584.29 | 1605.27 | 1630.74
BEL | 63.85 | 58.75 | 60.5 | 63.09999999999999 | 64.85 | 67.44999999999999 | 69.19999999999999 | 71.79999999999998
INDIGO | 976.10 | 924.5999999999999 | 962.8 | 983.5999999999999 | 1021.8 | 1042.6 | 1080.8 | 1101.6
JSWSTEEL | 177.05 | 170.56 | 175.58 | 178.96 | 183.98 | 187.36 | 192.38 | 195.76
HDFC | 1,662.65 | 1639.16 | 1668.58 | 1690.66 | 1720.08 | 1742.16 | 1771.58 | 1793.66
HDFCLIFE | 501.35 | 485.5 | 500.25 | 508.5 | 523.25 | 531.5 | 546.25 | 554.5
MINDTREE | 859.20 | 847.44 | 860.82 | 873.24 | 886.62 | 899.04 | 912.42 | 924.8399999999999
IDEA | 4.75 | 4.14 | 4.47 | 4.69 | 5.02 | 5.239999999999999 | 5.569999999999999 | 5.789999999999999
HAVELLS | 495.45 | 460.46 | 472.13 | 491.66 | 503.33 | 522.8599999999999 | 534.53 | 554.06
HDFCBANK | 898.95 | 875.2600000000001 | 898.6800000000001 | 913.1600000000001 | 936.58 | 951.0600000000001 | 974.48 | 988.96
ICICIBANK | 327.60 | 314.66 | 323.48 | 330.76 | 339.58 | 346.86 | 355.6799999999999 | 362.9599999999999
DLF | 136.55 | 131.4 | 135.5 | 138.3 | 142.4 | 145.2 | 149.3 | 152.1
M%26M | 399.40 | 390.59 | 397.42 | 405.24 | 412.07 | 419.89 | 426.72 | 434.54
LICHSGFIN | 265.30 | 253.34 | 262.57 | 268.54 | 277.77 | 283.74 | 292.97 | 298.9399999999999
IDFCFIRSTB | 21.05 | 18.93999999999999 | 19.82 | 20.84 | 21.72 | 22.74 | 23.62 | 24.64
NIITTECH | 1,367.10 | 1308.91 | 1358.48 | 1388.86 | 1438.43 | 1468.81 | 1518.38 | 1548.76
TATAMOTORS | 83.95 | 78.55000000000001 | 82.4 | 84.80000000000001 | 88.65 | 91.05000000000001 | 94.9 | 97.30000000000001
ZEEL | 158.95 | 144.1 | 149.65 | 157.4 | 162.95 | 170.7 | 176.25 | 184
CHOLAFIN | 151.65 | 140.11 | 146.93 | 152.31 | 159.13 | 164.51 | 171.33 | 176.71
POWERGRID | 160.20 | 151.99 | 157.02 | 161.84 | 166.87 | 171.69 | 176.72 | 181.54
INDUSINDBK | 431.00 | 399.9 | 422.2 | 435.4 | 457.7 | 470.9 | 493.2 | 506.4
TECHM | 523.00 | 515.84 | 523.62 | 534.19 | 541.97 | 552.5400000000001 | 560.32 | 570.8900000000001
[NAME] | 85.60 | 82.31 | 84.78 | 87.06 | 89.53 | 91.81 | 94.28 | 96.56
NTPC | 89.00 | 85.11000000000001 | 88.88000000000001 | 90.96000000000001 | 94.73 | 96.81 | 100.58 | 102.66
HINDALCO | 118.15 | 115.76 | 118.68 | 121.11 | 124.03 | 126.46 | 129.38 | 131.81
INFY | 663.00 | 669.1500000000001 | 676.45 | 685.3000000000001 | 692.6 | 701.45 | 708.75 | 717.6