Hello,
Can any one help with this question:

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

Known a
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.

In cell B2 enter:

=8000*(1-A2)

and just copy this down to the cells in column B that do not contain known
values.
--
Gary's Student


"Adjusting TOCto reflect page numbering" wrote:

Hello,
Can any one help with this question:

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

Known a
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.

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.

Adjusting TOCto reflect page numbering wrote:

Hello,
Can any one help with this question:

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

Known a
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.

--

Dave Peterson