HI DOES THIS EQUATION LOOK CORRECT PLEASE

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

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)
 
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
 
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
 
Back
Top