Linear Interpolation in Excel

To perform linear interpolation in Excel,  use the FORECAST function to interpolate between two pairs of x- and y-values directly. In the example below, the formula to interpolate and find the y-value that corresponds to an x-value of 1.4 is: =FORECAST(F2,C3:C4,B3:B4) This simple method works when there are only two pairs of x- and y-values.… Read more about Linear Interpolation in Excel Via EngineerExcel https://ift.tt/35IKMaF