Why QUOTIENT function is not being recognized?

[math function]

Why QUOTIENT function is not being recognized in Excell?
Is there another divide math funtion that could be used instead of QUOTIENT???

 

[Ron Rosenfeld]

Why QUOTIENT function is not being recognized in Excell?

How do you know it is not being recognized?

Is there another divide math funtion that could be used instead of QUOTIENT???

To "mimic" QUOTIENT, you could use =TRUNC(5/2)



--ron

 

[Rick Rothstein \(MVP - VB\)]

The QUOTIENT function requires the Analysis ToolPak add-in to be loaded.
However, are you sure you really want to use this function? I ask because
this is how the help files define it...

"Returns the integer portion of a division. Use this function
when you want to discard the remainder of a division."

Rick

 

[Ron Rosenfeld]

How do you know it is not being recognized?



To "mimic" QUOTIENT, you could use =TRUNC(5/2)



--ron

That should read:

To "mimic" =QUOTIENT(5,2), you could use =TRUNC(5/2)

--ron