OK, first let me say that I am a complete idiot in the ways of Excel. That
said, I need help entering a formula. Step by step would be nice or
direction to a tutorial. ( I have used the help file to no avail). What I
want is an Excel backup to what I use in the field on a TI-86 or an HP 33s.
I can enter and store the following on the handhelds but cannot seem to get
it right on Excel.
L-DxDx.0000006=
or
(LxD-D2)x.0000006=
Of course L and D are variables and the .0000006 remains static.
Thanks to anyone that can lead me in the right direction.
Ryan.Chowdhury@gmail.com - 22 Jul 2006 14:03 GMT
All Excel formulas begin with the = sign
and variable will take the form of named ranges or cell addresses
and finally multiplication is performed via the * sign or in some cases
the =Product() function.
so...
=L-D*D*.0000006
should work for you.
also exponents are created using the carrot, ^ so D squared would be
D^2.
Ryan
> OK, first let me say that I am a complete idiot in the ways of Excel. That
> said, I need help entering a formula. Step by step would be nice or
[quoted text clipped - 10 lines]
>
> Thanks to anyone that can lead me in the right direction.