Formula for: Format Decimal places?
Many Thanks.... I have a better understanding of what goes where in that
equation, and without fully knowing how the equation works yet, sorry,
intuition is that it is what I need, &, is probably more dynamic than what I
could have done... Many Thanks -Nastech
XXXXXXXXXX
"Ron Rosenfeld" wrote:
On Thu, 3 Nov 2005 21:15:01 -0800, "nastech"
wrote:
p.s. divide by 1000 might only work for every 10 power of 3, is that telling
the future, or what :) anyways, I maybe would utimately.. have cell that
works divsor to the power thing (3, 6, 9), stead of 1000000000000000000000
In the equations I recommended, try substituting your number of shares, or your
equation to compute the number shares, for "A1"
See if that gives you what you want.
For example:
=TRUNC($IN/Price,2-INT(LOG10($IN/Price)))/10^INT(LOG10($IN/Price))
=10^INT(LOG10($IN/Price))
--ron
|