LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"