Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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???
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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???


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
quotient function prob. i have copied example but it gives error Chris Whitehead Excel Discussion (Misc queries) 10 March 28th 07 12:06 AM
Make divisions and display no decimal value at the quotient! FreakyShadow Excel Discussion (Misc queries) 2 March 5th 06 05:28 AM
Worksheet VBA function - not recognized G Lykos Excel Worksheet Functions 4 August 23rd 05 05:50 AM
Data isn't being recognized. ConfusedDataMonkey Excel Worksheet Functions 1 January 20th 05 04:41 PM
How do I set a mimimum quotient value? Robert Excel Worksheet Functions 4 January 19th 05 07:50 PM


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"