Spreadsheet: 786331d1657117599-formula-to-find-greater-lesser-value-in-a-range-of-column-aslam5420-book7
Sheet: Sheet1

 |  |  |  |  |  |  | 5
 |  | 1 | 2 | 848.3299999999999 |  | Expected Results for < 1 | Expected Results for > 2
 |  |  |  | 849.7940000000001 | 0.482966547799695
 |  |  | 1849 | 849.8389999999999 | 0.1279458583157332
 |  |  | 1850 | 849.932 | -0.1696609524200829
 |  |  |  | 850.309 | 0.7926522573712341
 |  | 1830 |  | 850.5540000000001 | -1.957150141056379
 |  |  |  | 849.6389999999999 | 1.890691329707018
 |  |  |  | 848.885 | -1.118421159795282
 |  |  |  | 847.1659999999999 | 0.04831935118515412
 |  |  |  | 846.2760000000001 | -0.06256580459235311
 |  |  |  | 845.4960000000001 | 0.3291792323726315
 |  |  |  | 845.991 | 0.9397730936314079
 |  |  |  | 846.3499999999999 | -0.9747333554799923
 |  |  |  | 845.7460000000001 | -1.170597325433472
 |  |  |  | 847.1669999999999 | 2.20769123201704
 |  |  |  | 846.5509999999999 | -1.34232024127003
 |  |  |  | 847.2650000000001 | -0.3253515279568742
 |  |  |  | 846.675 | -1.290082823565199
 |  |  |  | 846.329 | 0.5995881305227708
 |  |  |  | 846.8209999999999 | -0.8345471306227952
 |  |  |  | 846.2239999999999 | 0.9730521983348566
 |  |  |  | 842.8340000000001 | -2.853483433305076
 |  |  |  | 844.877 | 6.627332207161659
 |  |  |  | 844.864 | -1.760442387583642
 |  |  |  | 845.1869999999999 | -1.051246226607771
 |  |  |  | 844.45 | -0.9911685234289059
 |  |  |  | 843.5260000000001 | -0.4384611158004805
 |  |  |  | 845.297 | 0.8081595506430251
 |  |  |  | 845.3720000000001 | 0.7286450989415183
 |  |  |  | 843.4300000000001 | -1.605883744898891
 |  |  |  | 844.048 | 0.01764751353584315
 |  |  |  | 841.559 | -0.2135967924253408
 |  |  |  | 841.7170000000001 | 1.383650014020314
 |  |  |  | 842.0029999999999 | 0.1376041838586367
 |  |  |  | 840.8389999999999 | 0.8757856599931747
 |  |  |  | 840.144 | -0.6695718716374677
 |  |  |  | 832.905 | -16.98061457017909
 |  |  |  | 834.469 | 19.0462473676532
 |  |  |  | 836.011 | 1.960247456291086
 |  |  |  | 834.039 | -3.3061544679881
 |  |  |  | 837.287 | -5.342852085327907
 |  |  |  | 850.684 | 40.8772863281845
 |  |  |  | 850.77 | 2.865866075527663
 |  |  |  | 847.471 | -50.41871952091
 |  |  |  | 848.7629999999999 | 17.40471368481847
 |  |  |  | 849.3130000000001 | 4.937090774295415
 |  |  |  | 848.538 | -4.729954295493531
 |  |  |  | 847.6959999999999 | 0.07420866831924755
 |  |  |  | 846.8910000000001 | -5.142655079297488
 |  |  |  | 846.278 | -1.395170040681558
 |  |  |  | 836.394 | -8.365511797204466
 |  |  |  | 837.913 | 10.27113041866073
 |  |  |  | 835.8050000000001 | -5.582144271932479
 |  |  |  | 835.752 | 1.808767136452286
 |  |  |  | 838.815 | 6.569024775962081
 |  |  |  | 840.1310000000001 | -3.999745915996353
 |  |  |  | 841.1800000000001 | -0.9615330279438544
 |  |  |  | 839.7850000000001 | -0.6158210156751565
 |  |  |  | 838.637 | 3.477606907396934
 |  |  |  | 837.4100000000001 | -4.978506338618296
 |  |  |  | 837.5 | 2.604157597934972
 |  |  |  | 836.6780000000001 | -0.957682394405104
 |  |  |  | 837.9159999999999 | 3.448767501632169
 |  |  |  | 836.816 | -5.061932373979704
 |  |  |  | 837.239 | 3.50767821945816
 |  |  |  | 837.1479999999999 | -0.6046789679273563
 |  |  |  | 837.31 | -0.1668082952686227
 |  |  |  | 836.905 | -0.3969289524546801
 |  |  |  | 836.5830000000001 | 1.598548585657398
 |  |  |  | 835.983 | -0.04336635150666313
 |  |  |  | 835.656 | -0.6245207868512797