need help with formula
What answer are you getting?
Are the figures in the 3 cells exactly as you've given them, or are they the
results of some formula and the values you've quoted perhaps the result of
some rounded display approximation to what is actually in the cell? Have
you tried formatting A1:A3 to more than 2 decimal places to see a better
approximation to what is really there?
Note also that the sort of numbers that you've quoted can't be represented
exactly in fixed point binary, so your answer will be an approximation
anyway (nominally to 15 figure accuracy).
--
David Biddulph
"mike" wrote in message
...
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
|