Spreadsheet: 870187d1716744496-finding-the-average-between-two-values-efaverageif
Sheet: Sheet1

 |  |  |  |  |  |  | Data 1 | Data 2 | Data 3
 |  |  |  |  |  |  | 0 | 100000 |  |  | 84.5
 |  |  |  |  |  |  | 1 | 99940.01799640054
 |  |  |  |  |  |  | 2 | 99910.04048785273
 |  |  |  |  |  |  | 3 | 99890.06047782277
 |  |  |  |  |  |  | 4 | 99880.07197120864
 |  |  |  |  |  |  | 5 | 99870.08446339524
 |  |  |  |  |  |  | 6 | 99860.09795428267
 |  |  |  |  |  |  | 7 | 99850.11244377108
 |  |  |  |  |  |  | 8 | 99840.12793176062
 |  |  |  |  |  |  | 9 | 99830.14441815145
 |  |  |  |  |  |  | 10 | 99820.16190284373
 |  |  |  |  |  |  | 11 | 99810.18038573762
 |  |  |  |  |  |  | 12 | 99790.22034573101
 |  |  |  |  |  |  | 13 | 99770.26429733323
 |  |  |  |  |  |  | 14 | 99740.33770725699
 |  |  |  |  |  |  | 15 | 99700.44955033732
 |  |  |  |  |  |  | 16 | 99650.61178604151
 |  |  |  |  |  |  | 17 | 99590.83935249313
 |  |  |  |  |  |  | 18 | 99521.15015900975
 |  |  |  |  |  |  | 19 | 99451.50973089194
 |  |  |  |  |  |  | 20 | 99371.9803391055
 |  |  |  |  |  |  | 21 | 99292.51454538987
 |  |  |  |  |  |  | 22 | 99213.11229888695
 |  |  |  |  |  |  | 23 | 99133.77354877928
 |  |  |  |  |  |  | 24 | 99054.49824429007
 |  |  |  |  |  |  | 25 | 98975.28633468311
 |  |  |  |  |  |  | 26 | 98896.13776926279
 |  |  |  |  |  |  | 27 | 98817.05249737401
 |  |  |  |  |  |  | 28 | 98738.03046840221
 |  |  |  |  |  |  | 29 | 98659.07163177327
 |  |  |  |  |  |  | 30 | 98580.17593695356
 |  |  |  |  |  |  | 31 | 98501.3433334498
 |  |  |  |  |  |  | 32 | 98422.57377080913
 |  |  |  |  |  |  | 33 | 98353.70207707463
 |  |  |  |  |  |  | 34 | 98275.05058020646
 |  |  |  |  |  |  | 35 | 98196.46197937401
 |  |  |  |  |  |  | 36 | 98117.9362242806
 |  |  |  |  |  |  | 37 | 98039.47326466971
 |  |  |  |  |  |  | 38 | 97951.27743280906
 |  |  |  |  |  |  | 39 | 97863.16094148849
 |  |  |  |  |  |  | 40 | 97765.34669582102
 |  |  |  |  |  |  | 41 | 97667.6302155084
 |  |  |  |  |  |  | 42 | 97560.25488952764
 |  |  |  |  |  |  | 43 | 97433.50896087493
 |  |  |  |  |  |  | 44 | 97287.46825534539
 |  |  |  |  |  |  | 45 | 97054.25829542524
 |  |  |  |  |  |  | 46 | 96811.92569165627
 |  |  |  |  |  |  | 47 | 96570.19816273802
 |  |  |  |  |  |  | 48 | 96319.44177208217
 |  |  |  |  |  |  | 49 | 96059.73004790004
 |  |  |  |  |  |  | 50 | 95791.13900670304
 |  |  |  |  |  |  | 51 | 95504.19621907144
 |  |  |  |  |  |  | 52 | 95208.59163462817
 |  |  |  |  |  |  | 53 | 94885.43210558011
 |  |  |  |  |  |  | 54 | 94525.55166946356
 |  |  |  |  |  |  | 55 | 94138.79031019332
 |  |  |  |  |  |  | 56 | 93716.11748092347
 |  |  |  |  |  |  | 57 | 93258.0317319049
 |  |  |  |  |  |  | 58 | 92774.3486328553
 |  |  |  |  |  |  | 59 | 92265.49035837567
 |  |  |  |  |  |  | 60 | 91722.72669254149
 |  |  |  |  |  |  | 61 | 91146.68993540377
 |  |  |  |  |  |  | 62 | 90519.94253998202
 |  |  |  |  |  |  | 63 | 89843.58249154853
 |  |  |  |  |  |  | 64 | 89100.96687490534
 |  |  |  |  |  |  | 65 | 88284.99719547959
 |  |  |  |  |  |  | 66 | 87389.06723458556
 |  |  |  |  |  |  | 67 | 86415.7703184643
 |  |  |  |  |  |  | 68 | 85367.90290879455
 |  |  |  |  |  |  | 69 | 84240.02680200245
 |  |  |  |  |  |  | 70 | 83027.3594981933
 |  |  |  |  |  |  | 71 | 81717.6641520642
 |  |  |  |  |  |  | 72 | 80292.0157693031
 |  |  |  |  |  |  | 73 | 78749.36277981312
 |  |  |  |  |  |  | 74 | 77066.61563760515
 |  |  |  |  |  |  | 75 | 75231.51201902734
 |  |  |  |  |  |  | 76 | 73256.73477474596
 |  |  |  |  |  |  | 77 | 71098.78058707654
 |  |  |  |  |  |  | 78 | 68777.05497112963
 |  |  |  |  |  |  | 79 | 66305.32336089328
 |  |  |  |  |  |  | 80 | 63673.6096793585
 |  |  |  |  |  |  | 81 | 60877.89799811089
 |  |  |  |  |  |  | 82 | 57903.05728230303
 |  |  |  |  |  |  | 83 | 54733.18432958244
 |  |  |  |  |  |  | 84 | 51381.08897500047
 |  |  |  |  |  |  | 85 | 47859.5263562301
 |  |  |  |  |  |  | 86 | 44175.49333953925
 |  |  |  |  |  |  | 87 | 40349.14423690546
 |  |  |  |  |  |  | 88 | 36414.61430595032
 |  |  |  |  |  |  | 89 | 32423.06933632807
 |  |  |  |  |  |  | 90 | 28444.93707362761
 |  |  |  |  |  |  | 91 | 24571.08109039297
 |  |  |  |  |  |  | 92 | 20906.71054173709
 |  |  |  |  |  |  | 93 | 17546.77523944401
 |  |  |  |  |  |  | 94 | 14542.42422192484
 |  |  |  |  |  |  | 95 | 11923.01047035512
 |  |  |  |  |  |  | 96 | 9694.611212056032
 |  |  |  |  |  |  | 97 | 7788.67056381459
 |  |  |  |  |  |  | 98 | 6137.823410994643
 |  |  |  |  |  |  | 99 | 4734.945355337806
 |  |  |  |  |  |  | 100 | 3568.945542757834