ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why QUOTIENT function is not being recognized? (https://www.excelbanter.com/excel-worksheet-functions/195206-why-quotient-function-not-being-recognized.html)

math function[_2_]

Why QUOTIENT function is not being recognized?
 
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?
 
On Wed, 16 Jul 2008 18:25:25 -0700, math function
wrote:

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\)[_947_]

Why QUOTIENT function is not being recognized?
 
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


"math function" wrote in message
...
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?
 
On Wed, 16 Jul 2008 21:33:46 -0400, Ron Rosenfeld
wrote:

On Wed, 16 Jul 2008 18:25:25 -0700, math function
wrote:

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


That should read:

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

--ron


All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com