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.