Need a formula

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I am not sure how to do this if some one could tell me how to do th
formula I would appreciate it

I want to enter a number in A1 and have it represent a value in A
The number in A1 would range from 1 to 150 and then number in A2 woul
always be a set value as shown belo
A1 A

1 = 2
2 = 25
3 = 3
4 = 59
5 = 7

Thanks Pete
 
Peter said:
I am not sure how to do this if some one could tell me how to do the
formula I would appreciate it

I want to enter a number in A1 and have it represent a value in A2
The number in A1 would range from 1 to 150 and then number in A2 would
always be a set value as shown below
A1 A2

1 = 22
2 = 25
3 = 37
4 = 59
5 = 71

Thanks Peter
Click to expand...

Hi Peter,

From your small sample, there isn't any obvious formula such as an
arithmetic progression (http://en.wikipedia.org/wiki/Arithmetic_progression)
or a geometric progression
(http://en.wikipedia.org/wiki/Geometric_progression). It might be possible
to contruct a polynomial expression to fit the numbers
(http://en.wikipedia.org/wiki/Polynomial_interpolation) but you'd need to
build it based on all 150 values to make sure you matched them all.

It might be better to store the data in an Excel spreadsheet, and write a
Word macro (see http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm) to
extract the value for A2 based on the number in A1.
 
Back
Top