 |
 | 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 / Worksheet Functions / May 2008HI DOES THIS EQUATION LOOK CORRECT PLEASE
I entered the following =QUOTIENT(PRODUCT(A1:C3),G1) where A1=3, C3=468.1 & G1=74.8151 the answer should be about 18 but excel gives it as 0 i think there may be some error with the program i have spent a lot of time on it and need to use the result as part of the next equation hence i need it to work. Please help Dan Either A1 or C3 or both are not being evaluated as numeric numbers. Select A1 and C3 then format as GENERAL or NUMBER then re-enter those values. Your formula correctly returns 18. You'll get the same result with this formula: =INT(A1*C3/G1)  SignatureBiff Microsoft Excel MVP >I entered the following > =QUOTIENT(PRODUCT(A1:C3),G1) [quoted text clipped - 9 lines] > > Dan In addition to Biff's comments, I'd like to point out that I doubt if you really would want to use the QUOTIENT function in your formula... the help files describe it as returning "the integer portion of a division" (note the word *integer* in there). By the way, the PRODUCT function (which works as one would expect) worked correctly for me on my worksheet (using your numbers as numbers). Rick >I entered the following > =QUOTIENT(PRODUCT(A1:C3),G1) [quoted text clipped - 9 lines] > > Dan You've told us what is in A1 and in C3, but you haven't told us what is in the other 7 elements of the A1:C3 range, Dan? If ABS(PRODUCT(7_other_elements)) is less than G1/PRODUCT(A1,C3), then your QUOTIENT formula will return zero. I would therefore guess that the product of the 7 other elements is between -0.0532757 and 0.0532757. SignatureDavid Biddulph >I entered the following > =QUOTIENT(PRODUCT(A1:C3),G1) [quoted text clipped - 9 lines] > > Dan Correction to that. I would therefore guess that the product of the 7 other elements is between 0 and 0.0532757, because if it were between -0.0532757 and 0 the QUOTIENT would return the rather confusing result of -0. SignatureDavid Biddulph > You've told us what is in A1 and in C3, but you haven't told us what is in > the other 7 elements of the A1:C3 range, Dan? [quoted text clipped - 16 lines] >> >> Dan Yes there was a zero value amongst the numbers hence the product of all those numbers being 0, i got the * and : functions confused... the INT formula is helpful too, thanks a lot Dan > Correction to that. > I would therefore guess that the product of the 7 other elements is between [quoted text clipped - 20 lines] > >> > >> Dan
|
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.