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