How To Extrapolate In Excel - BSUPERIOR
bsuite365.com › blog › excelAug 12, 2020 · To extrapolate data by formula, we need to use two points of the linear chart that we plotted before. A (a, b) B (c, d) The linear extrapolation formula is: Y (x)=b+ (x-a)* (d-b)/ (c-a) You can enter the formula according to two points of your data values and extrapolate the target value. Picture 1- The linear extrapolation formula in Excel