ExcelBanter - View Single Post

Chuck[_11_]

On Sun, 5 Oct 2008 09:48:33 -0700 (PDT), wrote:

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!
In general those are equations for parabolas, but because of the constants they
are going to be very close to straight lines. The equations would be written
exactly the same in Access. T^2 = T*T = "T squared" or the number times
itself. Generally in Excel and Access T^2 would be used. Some programming
languages do not recognize the "^" symbol, in that case T*T would be used.
It's been a long time but I believe that VB6 does not recognize the ^ symbol.

Chuck
--