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)

--
Biff
Microsoft Excel MVP


"Dan" wrote in message
...
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

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


"Dan" wrote in message
...
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

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

"Dan" wrote in message
...
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

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.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"Dan" wrote in message
...
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

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

"David Biddulph" wrote:

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.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"Dan" wrote in message
...
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