View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Charlotte Howard Charlotte Howard is offline
external usenet poster
 
Posts: 37
Default Formatting/calculations question

Hi,
It turns out that the person who asked me about this wanted something the
other way around.

So I used the ROUND function to 2dp, and he now believes he has all his data
correct. I did try to point out that Maths is very accurate, and that the
more decimal places you use the more accurate things are.

He didn't like the 1*2 = 2.8 example at all!

Thanks!