HI 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

T
Sun May 11 20:50:03 CDT 2008

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" <Dan@discussions.microsoft.com> wrote in message
news:366AD012-4FDF-42F0-8DAC-5E42787EAFD8@microsoft.com...
>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

Rick
Sun May 11 21:47:00 CDT 2008

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" <Dan@discussions.microsoft.com> wrote in message
news:366AD012-4FDF-42F0-8DAC-5E42787EAFD8@microsoft.com...
>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

David
Mon May 12 02:47:11 CDT 2008

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" <Dan@discussions.microsoft.com> wrote in message
news:366AD012-4FDF-42F0-8DAC-5E42787EAFD8@microsoft.com...
>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

David
Mon May 12 02:51:15 CDT 2008

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
news:fJ6dndDk38ViaLrVRVnyugA@bt.com...
> 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" <Dan@discussions.microsoft.com> wrote in message
> news:366AD012-4FDF-42F0-8DAC-5E42787EAFD8@microsoft.com...
>>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
>
>

Dan
Mon May 12 18:11:00 CDT 2008

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
> news:fJ6dndDk38ViaLrVRVnyugA@bt.com...
> > 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" <Dan@discussions.microsoft.com> wrote in message
> > news:366AD012-4FDF-42F0-8DAC-5E42787EAFD8@microsoft.com...
> >>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
> >
> >
>
>
>