 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005Excel QUOTIENT ; That's the matter with the formula ......
1. Enter the following formula into a worksheet cell :- 2. = QUOTIENT (36,16) + RQP 3. Where RQP (=26) is a Named Formula (well defined). 4. The given formula appears to calculate well until the partial evaluation in the Formula Bar gives #NAME? (that's apparently an error condition). 5. That means that when the function QUOTIENT is applied in a larger formula, it would stall thereof. 6. There are inevitably dithering moments at the expense of troublshooting. 7. Please share your experience. Regards. What's the definition of RQP? When I put 26 in a cell and name that cell RQP... =QUOTIENT(36,16)+RQP returns 28. *********** Regards, Ron XL2002, WinXP-Pro > 1. Enter the following formula into a worksheet cell :- > [quoted text clipped - 13 lines] > > 7. Please share your experience. Regards. 1. Precisely, RQP = 26 (well defined). 2. The given formula appears to calculate well until the partial evaluation in the Formula Bar gives #NAME? (that's apparently an error condition). 3. Thank you. The Quotient function requires that the Analysis ToolPak add-in is installed. Go to Tools/Add-ins and click on Analysis ToolPak, then hit OK. Your formula should now evaluate properly. Rgds, ScottO | 1. Precisely, RQP = 26 (well defined). | [quoted text clipped - 3 lines] | | 3. Thank you. 1. I've dunnit : Go to Tools/Add-ins and click on Analysis ToolPak, then hit OK. 2. The given formula appears to calculate well ; however, the partial evaluation in the Formula Bar gives #NAME? (that's apparently an error condition). 3. Thank you. See my other reply. It appears that the use of the defined name, RQP, also causes what I've described in my other post. Biff > 1. I've dunnit : Go to Tools/Add-ins and click on Analysis ToolPak, > then hit OK. [quoted text clipped - 4 lines] > > 3. Thank you. Try this: Requires that the analysis ToolPak add-in be installed. A1 = 1/1/2005 A2 = 1/10/2005 Formula: =NETWORKDAYS(A1,A2)+NETWORKDAYS(A1,A2) Now, highlight the entire formula in the formula bar then press F9. Now, highlight the individual functions one at a time and press F9. If you use Excel XP (2002) or later, select the formula cell and goto Tools>Formula Auditing>Evaluate Formula. Click the Evaluate button. > 6. There are inevitably dithering moments at the expense of > troublshooting. In the above sceniaro, that's what you might run into. This "feature" was discussed a while back and the most reasonable conclusion was that a formula that contains more than 1 function call to the ATP will behave like that. The formula will work and return a result (not withstanding the typical errors) but if you ever have to troubleshoot it, it can be a real challenge depending on the complexity! In the next version of Excel the ATP functions will be incorporated into the Excel program itself thus eliminating the add-in. Biff > 1. Enter the following formula into a worksheet cell :- > [quoted text clipped - 13 lines] > > 7. Please share your experience. Regards. Mr. Biff, 1. Thank you for your clarification. 2. A longer formula incorporating Quotient(A,B) stalls (until it's replaced by INT(A/B)). 3. So kind of you if you could point with a link to : 'This "feature" was discussed a while back and the most reasonable conclusion was that a formula that contains more than 1 function call to the ATP will behave like that.' 4. What's the interim workaround while the world awaits Excel 12 ? 5. Regards. See this: http://tinyurl.com/bzbm5 Biff > Mr. Biff, > [quoted text clipped - 11 lines] > > 5. Regards. tkt_tang@hotmail.com wrote... ... >2. A longer formula incorporating Quotient(A,B) stalls (until it's >replaced by INT(A/B)). ... >4. What's the interim workaround while the world awaits Excel 12 ? Don't screw around using a pointless function like QUOTIENT(x,y). Use TRUNC(x/y) rather than INT(x/y) if you want the same results as QUOTIENT when x and y have different signs. Mr. Harlan Grove, Thank you for your practical suggestion. Regards. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.