"Ron Rosenfeld" wrote:

On Thu, 3 Nov 2005 18:36:04 -0800, "nastech"
wrote:

Hi, I like the formula's, and if I guesse right, can see use for having data
on one line, especially in future if / when expand to be able to tabulate
running totals? (is that right?) Sorry, I'm trying to make sense.. reaching
here, but:

I have a fixed $IN (or dollars in); have to know how many shares to buy,
quick, when I need them; not picking shares 1st, hope I didn't spent too
much later.
Maybe I am slow, if knowing how to "adapt" that to my layout. But,

Result is for # of shares to BUY, I know it seems backwards.

Maybe I am the one who is backwards, don't know. How do I use the multplier?
Thanks.

I thought you indicated you wanted to express your result as a digit with two
decimals:

need to see number: e.g. 1085, to 1.08; (no rounding up)

The formula I posted will always reduce a number to that format, and also (in
the second equation) give you the divisor used to obtain that result. So in
the above, if you entered 1085, the formulas would show:

1.08 1,000

That is the same as I posted a few messages ago.

If that is not something you want, then I don't understand what it is that you
do want.

==========================

If you want to enter some number of dollars, and compute how many shares you
can buy with that, that's simple:

A1: Dollars available
A2: Stock price (per share)
A3: =INT(A1/A2)


--ron


XXXXXXXXXX

HI!, I am better understanding what to say / ask for, maybe was complex.

Thanks again, I'm ok, just was not understanding your equation because don't
understand it yet. Since I don't exactly get where to put them for my
application, needs two inputs:

$IN (dollars-in) & Last Price. Don't see 2 inputs for your eq.
Must have: $IN/Price=shares, so I can find shares.

2 decimals yes, Divide by 1000 is used to simulate "thousands" separator,
with decimal point, to ruduce digits (by hopefully, having variable decimal
positions: 2 or later, 1 if higher $).

That may be the last problem still have, not sure if your eqaution would
have variation to all change decimal places from 2, to 1 spot. (relatively
speaking: if over 1000 2 spots, if over 50,000 1 spot, maybe). 1000 good
for now.

Will check int( further as well. saw the word multiplier somewhere i
guesse, that' all? anyways will figure it out.

2 decimal places was what looking for, right up to here/now, found variation
with what tried with other:

=IF(AG9="","",IF($AT$51000,TEXT(TRUNC(($AT$5/AG9)/1000,2),"0.00"),TEXT(($AT$5/AG9),"#,##0")))

AT5 IS $IN (fee adjusted)

AG9 IS LAST PRICE, THIS EQ goes in BUY column for every instance of LAST
PRICE, ~2k records. But if get to over ~$50k (with my column width), need to
change decimal from 2 spots to 1. At that level, rounding down to one spot
should be ok?

1st prob: if can change from 2 to 1 decimal place on 1 cell command? /
automatic?
2nd prob: if not automatic, see results (maybe from use of TEXT), numbers
are sneaking under column to left, and not going: ####. ouch, well under
buy I guesse.

Hope all I did was crack you up... Any fix for above equation / your
equation? Just don't know where to put yours for what I "have" to do.. .
Bit closer anyways.
50k not that big of a number... later