HI DOES THIS EQUATION LOOK CORRECT PLEASE

[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

 

[T. Valko]

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)

 

[Rick Rothstein \(MVP - VB\)]

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

 

[David 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?

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.

 

[David Biddulph]

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.

 

[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