T^2

[jlute]

I'm trying to translate some Excel functions into an Access query but
I'm very ignorant regarding Excel functions and hope someone can
enlighten me!

The person who created the particular Excel functions used "T". Two
examples:

=0.5+0.001*T-0.0000005*T^2
=997.18+0.0031*T-0.0004*T*T

I've looked up T in the help file:
"Returns the text referred to by value."

Considering that the cells with the above functions are numeric as are
all of the cells on the sheet - what the heck are these functions
doing and why were they written this way?

Thanks in advance!

 

[JLGWhiz]

Te formulas that you posted appear to be simple mathematical equations where
T is a variable value. Without seeing the full code set it would be
difficult to absolutely define T, but if you substitute any number for T in
the equations, you will get a numeric result.

 

[Dave Peterson]

It looks as though the developer defined a name called T.
(Insert|Name|define in xl2003 menus).

You could go through that same menu to find out what T referred to--a cell, a
formula, a constant or whatever???

 

[Rick Rothstein]

It's been a long time but I believe that VB6 does not recognize the ^

symbol.

Yes, VB6 does indeed recognize the power symbol.

 

[Rick Rothstein]

It's been a (long, long) while since I looked at Turbo Pascal, but I thought
it used what Fortran (also been a long, long while since I looked at this
also) used for powers... the double asterisk symbol. I would have thought
your VB example of X^A would have been X**A in Turbo Pascal.

 

[jlute]

Thanks everybody! I realized the T "alias" shortly after I posted this
but poor internet connections prohibited my response.

I appreciate the info!

 

[Rick Rothstein]

It's been too long since I played with languages that used ** for powers,
but my recollection is that A could be a floating point value.