Why QUOTIENT function is not being recognized?

  • Thread starter Thread starter math function
  • Start date Start date
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???
 
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
 
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
 
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
 
Back
Top