View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
boya716 boya716 is offline
external usenet poster
 
Posts: 2
Default Subtracting Rounded Numbers

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?