Thread: formula error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default formula error

Display your cell contents with more decimal places so that you can see what
the cell contents *really* are.

4108.5 will display as 4109 if shown with zero decimal places.
43.855 will display as 43.86 if shown with 2 decimal places.
Multiply those, and you get 180178.3 so 180200 is well within your range of
uncertainty.
--
David Biddulph


"RC" wrote in message
...
something basic as : =(cell)*(cell) or 4,109 * 43.86. Should equate to
180,221; however displays as 180,200.

formula error flag is in upper left..but I can find nothing...any
suggestions?

Thanks all