View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Subtracting Rounded Numbers

What do you mean by "formatting with round" Are you formatting or using a
formula like

=ROUND(B1,1)


2.

4.0-1.6 equals 2.4, if it would subtract 1.55 it would be 2.45?


--


Regards,


Peo Sjoblom




"boya716" wrote in message
...
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?