Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Need a formula
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 |
#2
|
|||
|
|||
A2 is any of 150 possible values, depending on A1?
"Peter" wrote in message ... 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 |
#3
|
|||
|
|||
Peter wrote:
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 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/C...XLFromWord.htm) to extract the value for A2 based on the number in A1. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to word | Microsoft Word Help | |||
How do you create a formula in a table where the result appears a. | Tables | |||
field formula | Tables | |||
I need a formula of amount of hours from two times in two cell? | Tables | |||
Formula in table - Creating a final total from sub-total cells | Tables |