Spreadsheet: 73484d1274159233-finding-2-points-on-either-side-of-0-book1
Sheet: current system

-2 width | [NAME]
 |  | Cell A2: | I need a formula to find the two points closest to -2 in column B, take the respective values from column A and find the difference between those values.
 |  | Cell B2: | I also need to find the center point between the values used in A2.
1 | -45 |  | Right now I find these by hand.
1.01 | -45 |  | I tried V-lookup, but it only found the first of the two points.
1.02 | -45
1.03 | -45
1.04 | -45
1.05 | -40.5963732661698
1.06 | -40.5963732661698
1.07 | -40.5963732661698
1.08 | -40.5963732661698
1.09 | -40.5963732661698
1.1 | -40.5963732661698
1.11 | -40.5963732661698
1.12 | -40.5963732661698
1.13 | -37.58607900186951
1.14 | -37.58607900186951
1.15 | -37.58607900186951
1.16 | -37.58607900186951
1.17 | -37.58607900186951
1.18 | -37.58607900186951
1.19 | -37.58607900186951
1.2 | -37.58607900186951
1.21 | -37.58607900186951
1.22 | -37.58607900186951
1.23 | -35.82515692408431
1.24 | -35.82515692408431
1.25 | -35.82515692408431
1.26 | -35.82515692408431
1.27 | -35.82515692408431
1.28 | -35.82515692408431
1.29 | -35.82515692408431
1.3 | -34.57577904522969
1.31 | -34.57577904522969
1.32 | -34.57577904522969
1.33 | -34.57577904522969
1.34 | -34.57577904522969
1.35 | -33.60668460749611
1.36 | -33.60668460749611
1.37 | -33.60668460749611
1.38 | -33.60668460749611
1.39 | -32.81487594192199
1.4 | -32.81487594192199
1.41 | -32.81487594192199
1.42 | -32.81487594192199
1.43 | -32.81487594192199
1.44 | -32.81487594192199
1.45 | -32.14541075626227
1.46 | -32.14541075626227
1.47 | -32.14541075626227
1.48 | -31.56547908858988
1.49 | -31.05395702653014
1.5 | -31.05395702653014
1.51 | -30.5963846508563
1.52 | -30.5963846508563
1.53 | -30.18245986922025
1.54 | -29.80457598528218
1.55 | -29.45695638226869
1.56 | -29.45695638226869
1.57 | -29.45695638226869
1.58 | -29.13511079962245
1.59 | -28.83547965010706
1.6 | -28.55517913195007
1.61 | -28.29189141894551
1.62 | -27.80884744293855
1.63 | -27.58608469421648
1.64 | -27.58608469421648
1.65 | -27.17215991258044
1.66 | -26.79427602864237
1.67 | -26.44665642562888
1.68 | -26.2827655621528
1.69 | -25.82519487312219
1.7 | -25.54488629074515
1.71 | -25.28157806857237
1.72 | -24.91435633319369
1.73 | -24.57577904522969
1.74 | -24.26169903601857
1.75 | -23.87540219585782
1.76 | -23.52069896242632
1.77 | -23.19277017560589
1.78 | -22.74310347115192
1.79 | -22.40093701566266
1.8 | -22.0230571566107
1.81 | -21.56547908858988
1.82 | -21.15156258673496
1.83 | -20.77367374354852
1.84 | -20.34332943510095
1.85 | -19.91453809924884
1.86 | -19.42366578468667
1.87 | -18.98269991759817
1.88 | -18.50123197549708
1.89 | -18.06785357783723
1.9 | -17.62973596815773
1.91 | -17.15246768363146
1.92 | -16.65187500394448
1.93 | -16.18730504992436
1.94 | -15.72499733604897
1.95 | -15.18060058635133
1.96 | -14.64142150795485
1.97 | -14.06426963284924
1.98 | -13.50367756989411
1.99 | -12.90260240625819
2 | -12.24582110372222
2.01 | -11.58180406523356
2.02 | -10.87899194962236
2.03 | -10.21813664408779
2.04 | -9.531078036807797
2.05 | -8.78939678325095
2.06 | -8.089749496164705
2.07 | -7.401155054272547
2.08 | -6.667654026996686
2.09 | -5.978410523220612
2.1 | -5.262467169443335
2.11 | -4.550889577447588
2.12 | -3.849609047478606
2.13 | -3.183300129636789
2.14 | -2.565918078834587
2.15 | -2.044233635392076
2.16 | -1.60859847685185
2.17 | -1.207682850077735
2.18 | -0.8970969391686427
2.19 | -0.6510089963491428
2.2 | -0.4579013045179617
2.21 | -0.2984953850874866
2.22 | -0.1824598692202525
2.23 | -0.09529528136608817
2.24 | -0.02962446604405658
2.25 | -0.001131474064932653
2.26 | 0
2.27 | -0.03649429318833121
2.28 | -0.1228629071771671
2.29 | -0.2541089286679713
2.3 | -0.4537018943193665
2.31 | -0.7407711912934325
2.32 | -1.120084361663314
2.33 | -1.564411905360111
2.34 | -2.093000759735987
2.35 | -2.71612533611048
2.36 | -3.361821215903124
2.37 | -4.124518690501234
2.38 | -4.880458032892363
2.39 | -5.609149334054042
2.4 | -6.341048463017318
2.41 | -7.09971902848088
2.42 | -7.85019634818203
2.43 | -8.637395668228772
2.44 | -9.466986505116076
2.45 | -10.21018194809413
2.46 | -10.88827243850127
2.47 | -11.62562050591206
2.48 | -12.30978784758343
2.49 | -12.96960467644229
2.5 | -13.60668460749611
2.51 | -14.23151557335637
2.52 | -14.84452049303689
2.53 | -15.45091910083658
2.54 | -15.98742229584021
2.55 | -16.51397752653392
2.56 | -17.01704197307213
2.57 | -17.52143077727271
2.58 | -17.99567102121878
2.59 | -18.44794672573064
2.6 | -18.95284923100554
2.61 | -19.35786618680372
2.62 | -19.80457598528218
2.63 | -20.22212468489945
2.64 | -20.64003592479754
2.65 | -21.05395702653014
2.66 | -21.40560043513495
2.67 | -21.78824453368673
2.68 | -22.20788846362542
2.69 | -22.60298566186902
2.7 | -22.96211963313716
2.71 | -23.2724445226937
2.72 | -23.6944303561197
2.73 | -23.96880930396368
2.74 | -24.36389825242583
2.75 | -24.6857409159153
2.76 | -25.03335711325051
2.77 | -25.41123697230247
2.78 | -25.68277946447932
2.79 | -26.12481084298265
2.8 | -26.2827655621528
2.81 | -26.61698911801888
2.82 | -26.97910926060349
2.83 | -27.37419278777452
2.84 | -27.58608469421648
2.85 | -27.80884744293855
2.86 | -28.29189141894551
2.87 | -28.55517913195007
2.88 | -28.83547965010706
2.89 | -29.13511079962245
2.9 | -29.45695638226869
2.91 | -29.45695638226869
2.92 | -29.80457598528218
2.93 | -29.80457598528218
2.94 | -30.18245986922025
2.95 | -30.5963846508563
2.96 | -30.5963846508563
2.97 | -31.05395702653014
2.98 | -31.05395702653014
2.99 | -31.56547908858988
3 | -31.56547908858988
3.01 | -32.14541075626227
3.02 | -32.14541075626227
3.03 | -32.81487594192199
3.04 | -32.81487594192199
3.05 | -32.81487594192199
3.06 | -32.81487594192199
3.07 | -32.81487594192199
3.08 | -32.81487594192199
3.09 | -33.60668460749611
3.1 | -33.60668460749611
3.11 | -33.60668460749611
3.12 | -33.60668460749611
3.13 | -34.57577904522969
3.14 | -34.57577904522969
3.15 | -34.57577904522969
3.16 | -34.57577904522969
3.17 | -34.57577904522969
3.18 | -35.82515692408431
3.19 | -35.82515692408431
3.2 | -35.82515692408431
3.21 | -35.82515692408431
3.22 | -35.82515692408431
3.23 | -35.82515692408431
3.24 | -37.58607900186951
3.25 | -37.58607900186951
3.26 | -37.58607900186951
3.27 | -37.58607900186951
3.28 | -37.58607900186951
3.29 | -37.58607900186951
3.3 | -37.58607900186951
3.31 | -37.58607900186951
3.32 | -37.58607900186951
3.33 | -37.58607900186951
3.34 | -37.58607900186951
3.35 | -37.58607900186951
3.36 | -37.58607900186951
3.37 | -40.5963732661698
3.38 | -40.5963732661698
3.39 | -40.5963732661698
3.4 | -40.5963732661698
3.41 | -40.5963732661698
3.42 | -40.5963732661698
3.43 | -40.5963732661698
3.44 | -40.5963732661698
3.45 | -40.5963732661698
3.46 | -40.5963732661698
3.47 | -40.5963732661698
3.48 | -40.5963732661698
3.49 | -40.5963732661698
3.5 | -40.5963732661698
3.51 | -40.5963732661698
3.52 | -40.5963732661698
3.53 | -40.5963732661698
3.54 | -40.5963732661698
3.55 | -45
3.56 | -45
3.57 | -45
3.58 | -45
3.59 | -45
3.6 | -45
3.61 | -45
3.62 | -45
3.63 | -45
3.64 | -45
3.65 | -45
3.66 | -45
3.67 | -45
3.68 | -45
3.69 | -45
3.7 | -45
3.71 | -45
3.72 | -45
3.73 | -45
3.74 | -45
3.75 | -45
3.76 | -45
3.77 | -45
3.78 | -45
3.79 | -45
3.8 | -45
3.81 | -45
3.82 | -45
3.83 | -45
3.84 | -45
3.85 | -45
3.86 | -45
3.87 | -45
3.88 | -45
3.89 | -45
3.9 | -45
3.91 | -45
3.92 | -45
3.93 | -45
3.94 | -45
3.95 | -45
3.96 | -45
3.97 | -45
3.98 | -45
3.99 | -45
4 | -45