View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
iliace iliace is offline
external usenet poster
 
Posts: 229
Default Subtracting Rounded Numbers

Go to Options and check the Precision as Displayed function, is what
you're asking I think.

For reference, 4.0 less 1.6 does indeed equal to 2.4


On Nov 5, 4:31 pm, boya716 wrote:
I have two cells that I am trying to subtract. Say A1 is 4.0 and B1 is 1.55,
both are formatting with ROUND, so A1 rounds to 4.0 and B1 rounds to 1.6.
When subtracting these in cell C1, with ROUND function, it reads 2.4. It is
subtracting 1.55 from 4.0 instead of 1.6 from 4.0. How do I get it to
subtract the final rounded number?