Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: ATR%_Analysis_Short

 | ATR | 1/2 ATR | ATR Entry | Daily High | ATR Entry Minus | Open | High Minus Open |  | ATR Mult
 |  |  |  |  | High |  |  |  | 0.2
 | 0.4399999999999977 |  | 10.45 | 10.29 |  | 10.23
 | 1.099999999999994 |  | 38.43 | 38.06 |  | 37.88
 | 1.460000000000008 |  | 43.64 | 43.14 |  | 42.91
 | 3.300000000000011 |  | 111.43 | 110.47 |  | 109.78
 | 1.600000000000009 |  | 57.56 | 57.15 |  | 56.76
 | 1.400000000000006 |  | 36.7 | 36.24 |  | 36
 | 1.519999999999996 |  | 57.32 | 56.83 |  | 56.56
 | 0.4800000000000004 |  | 13.53 | 13.48 |  | 13.29
 | 0.7600000000000016 |  | 13.65 | 13.62 |  | 13.27
 | 0.6400000000000006 |  | 33.86 | 33.8 |  | 33.54
 | 0.7000000000000028 |  | 42.53 | 42.4 |  | 42.18
 | 0.3399999999999963 |  | 18.9 | 18.78 |  | 18.73
 | 0.519999999999996 |  | 37.22 | 37.12 |  | 36.96
 | 1.119999999999997 |  | 26.86 | 26.48 |  | 26.3
 | 0.2999999999999972 |  | 24.58 | 24.57 |  | 24.43
 | 3.200000000000017 |  | 101.31 | 100.43 |  | 99.71
 | 0.7999999999999972 |  | 26.56 | 26.47 |  | 26.16
 | 0.620000000000001 |  | 11.39 | 11.2 |  | 11.08
 | 0.5599999999999952 |  | 17.56 | 17.4 |  | 17.28
 | 1.099999999999994 |  | 28.47 | 28.46 |  | 27.92
 | 0.5600000000000023 |  | 17.43 | 17.22 |  | 17.15
 | 0.3000000000000007 |  | 8.07 | 7.97 |  | 7.92
 | 0.5599999999999952 |  | 23.2 | 23.03 |  | 22.92
 | 0.980000000000004 |  | 50.74 | 50.51 |  | 50.25
 | 0.519999999999996 |  | 33.75 | 33.65 |  | 33.49
 | 0.3999999999999986 |  | 12.27 | 12.21 |  | 12.07
 | 0.8599999999999994 |  | 20.9 | 20.68 |  | 20.47
 | 2.680000000000007 |  | 74.33 | 74.13 |  | 72.99
 | 1.219999999999999 |  | 52.61 | 52.2 |  | 52
 | 0.4200000000000017 |  | 19.44 | 19.32 |  | 19.23
 | 1.47999999999999 |  | 55.12 | 54.55 |  | 54.38
 | 1.320000000000007 |  | 34.7 | 34.18 |  | 34.04
 | 1.939999999999998 |  | 72.23 | 71.61 |  | 71.26
 | 0.6000000000000014 |  | 24.44 | 24.4 |  | 24.14
 | 0.5600000000000023 |  | 26.94 | 26.74 |  | 26.66
 | 1.02000000000001 |  | 40.74 | 40.71 |  | 40.23
 | 3.580000000000013 |  | 96.43 | 95.5 |  | 94.64
 | 2.099999999999994 |  | 67.67 | 67.34 |  | 66.62
 | 0.8200000000000003 |  | 28.14 | 27.99 |  | 27.73
 | 1.079999999999984 |  | 66.38 | 66.12 |  | 65.84
 | 0.3400000000000034 |  | 23.57 | 23.48 |  | 23.4
 | 0.6599999999999966 |  | 51.16 | 51.01 |  | 50.83
 | 0.4000000000000057 |  | 16.53 | 16.5 |  | 16.33
 | 1.319999999999993 |  | 63.58 | 63.49 |  | 62.92
 | 1.040000000000006 |  | 42.39 | 42.35 |  | 41.87
 | 0.9400000000000119 |  | 54.27 | 54.08 |  | 53.8
 | 0.4600000000000009 |  | 16.36 | 16.32 |  | 16.13
 | 0.9399999999999977 |  | 54.93 | 54.83 |  | 54.46
 | 2.060000000000002 |  | 92.05 | 91.34 |  | 91.02
 | 1 |  | 43.33 | 43.22 |  | 42.83
 | 0.4200000000000017 |  | 22.51 | 22.36 |  | 22.3
 | 1.020000000000003 |  | 11.55 | 11.29 |  | 11.04
 | 0.21 |  | 3.64 | 3.62 |  | 3.52
 | 1.51 |  | 23.4 | 23.28 |  | 22.64
 | 1.51 |  | 41.67 | 41.6 |  | 40.91
 | 2.94 |  | 91.03 | 89.98 |  | 89.56
 | 2.2 |  | 28.54 | 28.33 |  | 27.52
 | 1.57 |  | 25.55 | 25.07 |  | 24.77
 | 2.06 |  | 74.11 | 73.61 |  | 73.08
 | 18.09 |  | 592.76 | 591.83 |  | 583.72
 | 2.13 |  | 47.36 | 46.6 |  | 46.29
 | 0.51 |  | 10.03 | 9.86 |  | 9.78
 | 0.45 |  | 7.69 | 7.56 |  | 7.47
 | 1.37 |  | 25.34 | 24.8 |  | 24.66
 | 0.4 |  | 15.45 | 15.34 |  | 15.25
 | 2.32 |  | 82.93 | 82.35 |  | 81.77
 | 1.66 |  | 33.82 | 33.2 |  | 32.99
 | 1.49 |  | 39.66 | 39.22 |  | 38.92
 | 1.81 |  | 40.91 | 40.49 |  | 40.01
 | 1.63 |  | 67.05 | 66.61 |  | 66.28
 | 1.39 |  | 51.18 | 51.09 |  | 50.48
 | 1.4 |  | 45.87 | 45.86 |  | 45.17
 | 1.78 |  | 46.38 | 45.67 |  | 45.49
 | 0.36 |  | 6.53 | 6.4 |  | 6.35
 | 0.53 |  | 13.93 | 13.91 |  | 13.67
 | 1.63 |  | 81.77 | 81.23 |  | 80.95
 | 0.55 |  | 12.92 | 12.76 |  | 12.65
 | 0.48 |  | 17.1 | 17.06 |  | 16.86
 | 1.02 |  | 29.82 | 29.46 |  | 29.31
 | 0.49 |  | 21.82 | 21.75 |  | 21.58
 | 0.5 |  | 12 | 11.95 |  | 11.75
 | 0.38 |  | 12.7 | 12.69 |  | 12.51
 | 0.88 |  | 22.52 | 22.33 |  | 22.08
 | 0.93 |  | 25.77 | 25.53 |  | 25.3
 | 1.83 |  | 99.47 | 99.4 |  | 98.56
 | 1.22 |  | 28.2 | 27.68 |  | 27.59
 | 1.180000000000007 |  | 59.32 | 58.82 |  | 58.73
 | 0.9599999999999937 |  | 32.19 | 31.8 |  | 31.71
 | 0.5599999999999952 |  | 25.15 | 24.91 |  | 24.87
 | 0.5 |  | 17.95 | 17.74 |  | 17.7
 | 0.92 |  | 27.45 | 27.06 |  | 26.99
 | 1.04 |  | 23.38 | 22.96 |  | 22.86
 | 0.62 |  | 11.02 | 10.75 |  | 10.71
 | 1.03 |  | 18.7 | 18.25 |  | 18.18
 | 0.57 |  | 25.32 | 25.09 |  | 25.04
 | 0.8599999999999994 |  | 23.66 | 23.23 |  | 23.23
 | 0.4400000000000013 |  | 14.47 | 14.26 |  | 14.25
 | 1 |  | 40.6 | 40.1 |  | 40.1
 | 0.5 |  | 18.78 | 18.55 |  | 18.53
 | 1.66 |  | 14.22 | 13.43 |  | 13.39
 | 0.6199999999999974 |  | 22 | 21.71 |  | 21.69
 | 0.740000000000002 |  | 26.68 | 26.34 |  | 26.31
 | 0.2799999999999976 |  | 10.45 | 10.31 |  | 10.31
 | 1.019999999999996 |  | 54.07 | 53.6 |  | 53.56
 | 0.5399999999999991 |  | 24.69 | 24.42 |  | 24.42
 | 1.480000000000004 |  | 55.81 | 55.07 |  | 55.07
 | 0.9200000000000017 |  | 62.94 | 62.5 |  | 62.48
 | 0.5 |  | 17.6 | 17.36 |  | 17.35
 | 1.740000000000009 |  | 109.39 | 108.57 |  | 108.52
 | 0.49 |  | 6.61 | 6.37 |  | 6.37
 | 1.32 |  | 37.28 | 36.62 |  | 36.62
 | 0.45 |  | 11.35 | 11.13 |  | 11.13
 | 0.81 |  | 33.82 | 33.45 |  | 33.42
 | 0.4 |  | 13.88 | 13.68 |  | 13.68
 | 1.21 |  | 43.32 | 42.74 |  | 42.72