Thread: T^2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jlute@marzetti.com is offline
external usenet poster
 
Posts: 5
Default T^2

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

I appreciate the info!

On Oct 5, 1:35*pm, JLGWhiz wrote:
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.



" 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!- Hide quoted text -


- Show quoted text -