need help with formula
Note also that formatting does not change the underlying values, so if you
are using cell references to the results of formulas instead of explicitly
entered constants 1531.23, 12700.45, and 7034.54, then the result might be
anywhere between 848.1157 and 848.1232 depending on what is in the 3rd+
decimal places of these numbers.
Jerry
"Dave F" wrote:
What value are you expecting to get?
=A1/A2*A3 resolves to the same value as =(A1/A2)*A3. Using your numbers, I
get 848.1195 either way.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"mike" wrote:
when i do a =(a1/a2)*a3--- the answer is not correct...... i am doing
numbers like 1531.23 / 12700.45 * 7034.54----- it is not giving me the same
answer as a calculator.. ????????????????? why
--
thx mike
|