Interpolating but with 10 Numbers between each value

[kdgreen]

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.
[TABLE="width: 315"]
<colgroup><col span="3"><col><col></colgroup><tbody>[TR]
[TD="align: right"]-90.000[/TD]
[TD="align: right"]0.1531[/TD]
[TD][/TD]
[TD="align: right"]-90.0[/TD]
[TD="align: right"]0.1531[/TD]
[/TR]
[TR]
[TD="align: right"]-89.000[/TD]
[TD="align: right"]0.1573[/TD]
[TD][/TD]
[TD="align: right"]-89.9[/TD]
[TD="align: right"]0.1535[/TD]
[/TR]
[TR]
[TD="align: right"]-88.000[/TD]
[TD="align: right"]0.1609[/TD]
[TD][/TD]
[TD="align: right"]-89.8[/TD]
[TD="align: right"]0.1539[/TD]
[/TR]
[TR]
[TD="align: right"]-87.000[/TD]
[TD="align: right"]0.1675[/TD]
[TD][/TD]
[TD="align: right"]-89.7[/TD]
[TD="align: right"]0.1544[/TD]
[/TR]
[TR]
[TD="align: right"]-86.000[/TD]
[TD="align: right"]0.1709[/TD]
[TD][/TD]
[TD="align: right"]-89.6[/TD]
[TD="align: right"]0.1548[/TD]
[/TR]
[TR]
[TD="align: right"]-85.000[/TD]
[TD="align: right"]0.1764[/TD]
[TD][/TD]
[TD="align: right"]-89.5[/TD]
[TD="align: right"]0.1552[/TD]
[/TR]
[TR]
[TD="align: right"]-84.000[/TD]
[TD="align: right"]0.1815[/TD]
[TD][/TD]
[TD="align: right"]-89.4[/TD]
[TD="align: right"]0.1556[/TD]
[/TR]
[TR]
[TD="align: right"]-83.000[/TD]
[TD="align: right"]0.1872[/TD]
[TD][/TD]
[TD="align: right"]-89.3[/TD]
[TD="align: right"]0.1560[/TD]
[/TR]
[TR]
[TD="align: right"]-82.000[/TD]
[TD="align: right"]0.1925[/TD]
[TD][/TD]
[TD="align: right"]-89.2[/TD]
[TD="align: right"]0.1565[/TD]
[/TR]
[TR]
[TD="align: right"]-81.000[/TD]
[TD="align: right"]0.1987[/TD]
[TD][/TD]
[TD="align: right"]-89.1[/TD]
[TD="align: right"]0.1569[/TD]
[/TR]
[TR]
[TD="align: right"]-80.000[/TD]
[TD="align: right"]0.2047[/TD]
[TD][/TD]
[TD="align: right"]-89.0[/TD]
[TD="align: right"]0.1573[/TD]
[/TR]
[TR]
[TD="align: right"]-79.000[/TD]
[TD="align: right"]0.2113[/TD]
[TD][/TD]
[TD="align: right"]-88.9[/TD]
[TD="align: right"]0.1577[/TD]
[/TR]
[TR]
[TD="align: right"]-78.000[/TD]
[TD="align: right"]0.218[/TD]
[TD][/TD]
[TD="align: right"]-88.8[/TD]
[TD="align: right"]0.1580[/TD]
[/TR]
[TR]
[TD="align: right"]-77.000[/TD]
[TD="align: right"]0.2251[/TD]
[TD][/TD]
[TD="align: right"]-88.7[/TD]
[TD="align: right"]0.1584[/TD]
[/TR]
[TR]
[TD="align: right"]-76.000[/TD]
[TD="align: right"]0.232[/TD]
[TD][/TD]
[TD="align: right"]-88.6[/TD]
[TD="align: right"]0.1587[/TD]
[/TR]
[TR]
[TD="align: right"]-75.000[/TD]
[TD="align: right"]0.2402[/TD]
[TD][/TD]
[TD="align: right"]-88.5[/TD]
[TD="align: right"]0.1591[/TD]
[/TR]
[TR]
[TD="align: right"]-74.000[/TD]
[TD="align: right"]0.2467[/TD]
[TD][/TD]
[TD="align: right"]-88.4[/TD]
[TD="align: right"]0.1595[/TD]
[/TR]
[TR]
[TD="align: right"]-73.000[/TD]
[TD="align: right"]0.2558[/TD]
[TD][/TD]
[TD="align: right"]-88.3[/TD]
[TD="align: right"]0.1598[/TD]
[/TR]
[TR]
[TD="align: right"]-72.000[/TD]
[TD="align: right"]0.264[/TD]
[TD][/TD]
[TD="align: right"]-88.2[/TD]
[TD="align: right"]0.1602[/TD]
[/TR]
[TR]
[TD="align: right"]-71.000[/TD]
[TD="align: right"]0.2731[/TD]
[TD][/TD]
[TD="align: right"]-88.1[/TD]
[TD="align: right"]0.1605[/TD]
[/TR]
[TR]
[TD="align: right"]-70.000[/TD]
[TD="align: right"]0.2818[/TD]
[TD][/TD]
[TD="align: right"]-88.0[/TD]
[TD="align: right"]0.1609[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the forum.

Try:

Book1
	A	B	C	D
1	-90	0.1531	-90	0.1531
2	-89	0.1573	-89.9	0.1535
3	-88	0.1609	-89.8	0.1539
4	-87	0.1675	-89.7	0.1544
5	-86	0.1709	-89.6	0.1548
6	-85	0.1764	-89.5	0.1552
7	-84	0.1815	-89.4	0.1556
8	-83	0.1872	-89.3	0.1560
9	-82	0.1925	-89.2	0.1565
10	-81	0.1987	-89.1	0.1569
11	-80	0.2047	-89	0.1573
12	-79	0.2113	-88.9	0.1577
13	-78	0.218	-88.8	0.1580
14	-77	0.2251	-88.7	0.1584
15	-76	0.232	-88.6	0.1587
16	-75	0.2402	-88.5	0.1591
17	-74	0.2467	-88.4	0.1595
18	-73	0.2558	-88.3	0.1598
19	-72	0.264	-88.2	0.1602
20	-71	0.2731	-88.1	0.1605
21	-70	0.2818	-88	0.1609
Sheet9

Cell Formulas
Range	Formula
C1	=$A$1+(ROW()-1)*0.1
D1	=OFFSET($B$1,(ROW()-1)/10,0)+MOD(ROW()-1,10)*(OFFSET($B$2,(ROW()-1)/10,0)-OFFSET($B$1,(ROW()-1)/10,0))/10

Put the formulas in C1:D1 and drag down as far as needed.

 

[kdgreen]

Thank you so much that worked perfectly.

 

[Eric W]

Happy to help.