Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |