software

i am running excell 2003 and am trying to use the quotient function.

I have found the ms help on the web and even copied and pasted the example
but all i get is an error. It is like my version of excel doesnt have the
quotient function at all, it isnt listed in the list of functions locally but
i get lots of refs to it here at MS office site?

Help Please

It is part of the Analysis ToolPak Add-In. To Install this:

Select Tools
Then Add-Ins...
Check the box next to Analysis TookPak
Click OK
Re-enter your formula (or recalculate 'F9')

If you don't see the Analysis ToolPak as an option, then you need to
reinstall it from your Office CD.

HTH,
Elkarquot;Chris Whiteheadquot; wrote:

gt; i am running excell 2003 and am trying to use the quotient function.
gt;
gt; I have found the ms help on the web and even copied and pasted the example
gt; but all i get is an error. It is like my version of excel doesnt have the
gt; quotient function at all, it isnt listed in the list of functions locally but
gt; i get lots of refs to it here at MS office site?
gt;
gt; Help Please

Why would you want to use:

=quotient(a1,b1)
instead of
=int(a1/b1)

Just curious.
Chris Whitehead wrote:
gt;
gt; i am running excell 2003 and am trying to use the quotient function.
gt;
gt; I have found the ms help on the web and even copied and pasted the example
gt; but all i get is an error. It is like my version of excel doesnt have the
gt; quotient function at all, it isnt listed in the list of functions locally but
gt; i get lots of refs to it here at MS office site?
gt;
gt; Help Please

--

Dave Peterson

quot;Dave Petersonquot; wrote:
gt; Why would you want to use:
gt; =quotient(a1,b1) instead of =int(a1/b1)

Isn't quotient(a1,b1) more like roundown(a1/b1,0)
than int(a1/b1)? The difference seems to arise when
a1/b1 is negative, for example -10/3.

Not sure, i am a bit new to this i just need the full integer and not the
rest for one part of the formula and i need the remainder (MOD) for the rest

quot;Dave Petersonquot; wrote:

gt; Why would you want to use:
gt;
gt; =quotient(a1,b1)
gt; instead of
gt; =int(a1/b1)
gt;
gt; Just curious.
gt;
gt;
gt;
gt; Chris Whitehead wrote:
gt; gt;
gt; gt; i am running excell 2003 and am trying to use the quotient function.
gt; gt;
gt; gt; I have found the ms help on the web and even copied and pasted the example
gt; gt; but all i get is an error. It is like my version of excel doesnt have the
gt; gt; quotient function at all, it isnt listed in the list of functions locally but
gt; gt; i get lots of refs to it here at MS office site?
gt; gt;
gt; gt; Help Please
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Maybe:

=trunc(a1/b1)

just in case???wrote:
gt;
gt; quot;Dave Petersonquot; wrote:
gt; gt; Why would you want to use:
gt; gt; =quotient(a1,b1) instead of =int(a1/b1)
gt;
gt; Isn't quotient(a1,b1) more like roundown(a1/b1,0)
gt; than int(a1/b1)? The difference seems to arise when
gt; a1/b1 is negative, for example -10/3.

--

Dave Peterson

I think I'd use =int() or =trunc() instead to get that quotient, though.
Chris Whitehead wrote:
gt;
gt; Not sure, i am a bit new to this i just need the full integer and not the
gt; rest for one part of the formula and i need the remainder (MOD) for the rest
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Why would you want to use:
gt; gt;
gt; gt; =quotient(a1,b1)
gt; gt; instead of
gt; gt; =int(a1/b1)
gt; gt;
gt; gt; Just curious.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Chris Whitehead wrote:
gt; gt; gt;
gt; gt; gt; i am running excell 2003 and am trying to use the quotient function.
gt; gt; gt;
gt; gt; gt; I have found the ms help on the web and even copied and pasted the example
gt; gt; gt; but all i get is an error. It is like my version of excel doesnt have the
gt; gt; gt; quotient function at all, it isnt listed in the list of functions locally but
gt; gt; gt; i get lots of refs to it here at MS office site?
gt; gt; gt;
gt; gt; gt; Help Please
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

And it may just boil down to what the OP wants--no matter what =quotient(),
=int() and =trunc() return.

But I think it's good that you showed the difference.
wrote:
gt;
gt; quot;Dave Petersonquot; wrote:
gt; gt; Why would you want to use:
gt; gt; =quotient(a1,b1) instead of =int(a1/b1)
gt;
gt; Isn't quotient(a1,b1) more like roundown(a1/b1,0)
gt; than int(a1/b1)? The difference seems to arise when
gt; a1/b1 is negative, for example -10/3.

--

Dave Peterson

Hi. Just 2 cents. The primary definition of Quotient is Floor (x)
functions.wolfram.com/IntegerFunctions/Quotient

In math, Quotient (-5,3) returns -2, but Excel returns -1.
It's hard to tell where the problem is with Excel because Floor (-2.5)
returns -3 in math programs, but Excel rounds towards 0 and returns -2.
Excel operates quot;a little differentlyquot; shall we say. Again...just 2 cents.
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot; gt; wrote
in message ...
gt; quot;Dave Petersonquot; wrote:
gt;gt; Why would you want to use:
gt;gt; =quotient(a1,b1) instead of =int(a1/b1)
gt;
gt; Isn't quotient(a1,b1) more like roundown(a1/b1,0)
gt; than int(a1/b1)? The difference seems to arise when
gt; a1/b1 is negative, for example -10/3.
In article gt;,
says...
gt; Excel operates quot;a little differentlyquot; shall we say. Again...just 2 cents.
gt;
LOL! That's being polite.

To me it seems that the original analysts/programmers assigned the task of
developing various math and stats functions did not know their math (or
stats) or were given very poor specs and made up rules as they went along.

For example, the help for Floor claims quot;Rounds number down, toward zero...quot;
That's simply impossible for negative numbers.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,
says...
gt; Hi. Just 2 cents. The primary definition of Quotient is Floor (x)
gt; functions.wolfram.com/IntegerFunctions/Quotient
gt;
gt; In math, Quotient (-5,3) returns -2, but Excel returns -1.
gt; It's hard to tell where the problem is with Excel because Floor (-2.5)
gt; returns -3 in math programs, but Excel rounds towards 0 and returns -2.
gt; Excel operates quot;a little differentlyquot; shall we say. Again...just 2 cents.
gt;