More of a challenge than for myself (in fact it's not for myself).
Can anyone think of a way to work out seemingly illogical differences in numbers.
The reason I ask and further clarification is that we all know that Celsius to Fahrenheit is ((Number*9)/5)+32 (well, if you didn't, you all do now)
If you had say a sample set of numbers C in ColumnA and F in ColumnB and you didn't know the logical reasons for the difference in them. Is possible to program Excel in such a way that it will return the most logical formula. Say return an equation in a disired cell
Anyone get that?
_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-03-28 11:16
Can anyone think of a way to work out seemingly illogical differences in numbers.
The reason I ask and further clarification is that we all know that Celsius to Fahrenheit is ((Number*9)/5)+32 (well, if you didn't, you all do now)
If you had say a sample set of numbers C in ColumnA and F in ColumnB and you didn't know the logical reasons for the difference in them. Is possible to program Excel in such a way that it will return the most logical formula. Say return an equation in a disired cell
Anyone get that?
_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-03-28 11:16