If you've changed the format of the cell to a single decimal place you will
see the value as if it were rounded, but values do not change with the
formatting. The only thing formatting does is change the appearance of a
value.

To round a value use the ROUND function

=ROUND(Value to round,x...xx")

Where x represents the number of decimal positions to round the value to.
--
Kevin Backmann


"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?