Interpolation is a method used to determine a present or future value factor when the exact factor does not appear in either a present or future value table. Interpolation assumes that the change between two values is linear and that the margin of error is insignificant.
- Type the following values in a worksheet:
A1: 9 B1: =(A7-A1)/(ROW(A7)-ROW(A1))
- Select cells A2:A6. On the Edit menu, point to Fill, and then click Down. The formula is filled down, and the following values are displayed in cells A2:A6:
Makale No: 214096 - Son İnceleme: 23 Eyl 2015 - Düzeltme: 1