quotient function prob. i have copied example but it gives error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
Elkar
 
Dave Peterson said:
Why would you want to use:
=quotient(a1,b1) instead of =int(a1/b1)
Click to expand...

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
 
Maybe:

=trunc(a1/b1)

just in case???



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.
Click to expand...
 
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.
 
Hi. Just 2 cents. The primary definition of Quotient is Floor (x)
http://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 "a little differently" shall we say. Again...just 2 cents.
 
Excel operates "a little differently" shall we say. Again...just 2 cents.
Click to expand...
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 "Rounds number down, toward zero..."
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
 
Dave Peterson said:
I think I'd use =int() or =trunc() instead to get that quotient, though.
Click to expand...

Quotient function in excel is rather buggy:
given d=divisior, D=dividend; Q=quotient; R=rest
d D Q R
5 10 0 5
-5 10 -0 5
5 -10 -0 -5
-5 -10 0 -5

Apart the very funny invention of the concept of -0 in excel, now if we apply
the rule d=D*q+r we get that is verified only for the first and the fourth
expression not for the second and the third.

Forget about quotient
Also for the math definition of rest 0<=R<|D| so R should always be > 0

But that is a long time bug, probably correcting it will break compatibility
with a lot of spreadsheets.
 
Back
Top