Right I have numbers from -90 to 90 by 1 with values and I need to interpolate numbers from -90 to 90 by 0.1. I need my formula to skip 10 cells then increase to use new numbers to interpolate, so for numbers between -90 and -89 it uses those values then -89 to -88 for the next 10 interpolated numbers. I don't know if I explained it fully if there is any futher explanation needed please ask. Here's sample of my data to explain better maybe,
Values that I have. Interpolated numbers.
<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>
Values that I have. Interpolated numbers.
-90.000 | 0.1531 | -90.0 | 0.1531 | |
-89.000 | 0.1573 | -89.9 | 0.1535 | |
-88.000 | 0.1609 | -89.8 | 0.1539 | |
-87.000 | 0.1675 | -89.7 | 0.1544 | |
-86.000 | 0.1709 | -89.6 | 0.1548 | |
-85.000 | 0.1764 | -89.5 | 0.1552 | |
-84.000 | 0.1815 | -89.4 | 0.1556 | |
-83.000 | 0.1872 | -89.3 | 0.1560 | |
-82.000 | 0.1925 | -89.2 | 0.1565 | |
-81.000 | 0.1987 | -89.1 | 0.1569 | |
-80.000 | 0.2047 | -89.0 | 0.1573 | |
-79.000 | 0.2113 | -88.9 | 0.1577 | |
-78.000 | 0.218 | -88.8 | 0.1580 | |
-77.000 | 0.2251 | -88.7 | 0.1584 | |
-76.000 | 0.232 | -88.6 | 0.1587 | |
-75.000 | 0.2402 | -88.5 | 0.1591 | |
-74.000 | 0.2467 | -88.4 | 0.1595 | |
-73.000 | 0.2558 | -88.3 | 0.1598 | |
-72.000 | 0.264 | -88.2 | 0.1602 | |
-71.000 | 0.2731 | -88.1 | 0.1605 | |
-70.000 | 0.2818 | -88.0 | 0.1609 |
<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>