Why QUOTIENT function is not being recognized?

M

math function

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

Ron Rosenfeld

Why QUOTIENT function is not being recognized in Excell?
Click to expand...

How do you know it is not being recognized?

Is there another divide math funtion that could be used instead of QUOTIENT???
Click to expand...

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



--ron
 
R

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
 
R

Ron Rosenfeld

How do you know it is not being recognized?



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



--ron
Click to expand...

That should read:

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

--ron
 
Top