HI DOES THIS EQUATION LOOK CORRECT PLEASE
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
|