View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default HI DOES THIS EQUATION LOOK CORRECT PLEASE

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