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
|