![]() |
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??? |
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 |
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??? |
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