Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why QUOTIENT function is not being recognized in Excell?
Is there another divide math funtion that could be used instead of QUOTIENT??? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
quotient function prob. i have copied example but it gives error | Excel Discussion (Misc queries) | |||
Make divisions and display no decimal value at the quotient! | Excel Discussion (Misc queries) | |||
Worksheet VBA function - not recognized | Excel Worksheet Functions | |||
Data isn't being recognized. | Excel Worksheet Functions | |||
How do I set a mimimum quotient value? | Excel Worksheet Functions |