Thread: 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"
> <nastech@discussions.microsoft.com> 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
>

On Fri, 4 Nov 2005 06:00:04 -0800, "nastech"
<nastech@discussions.microsoft.com> wrote:

>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

You're welcome.

As to what the equation is doing:

The equation changes the value (A1 or $IN/Price) to three significant digits
divided by 100 -- so as to give you your 0.00 type of output. In order to do
that, it divides the original by some multiple of 10; that multiple is the
output of the second formula.

Hope it helps you.
--ron