Interpolating tables

[Guest]

Hello,
Can any one help with this question:

A1: A51 => 50% to 100% (in 1% steps)
B1: B51 => Readings corresponding to the percents.

Known are:
50% =>4000
70% =>2400
80% =>1600
95% =>400
97% =>240
99% =>80
100% =>0

Required is to know how to interpolate and fill out the remaining percent
cells.

Thanks in advance.

 

[Guest]

In cell B2 enter:

=8000*(1-A2)

and just copy this down to the cells in column B that do not contain known
values.

 

[Dave Peterson]

Maybe you don't need a table.

If A1 contained the percentage, then you could use a formula:
=(1-a1)*8000

If you really needed a table.

Put this in A1:
=(ROW()-1)/100

Put this in B1:
=(1-a1)*8000

And select A1:B1
and use the fill handle to drag down to row 101.