Format the original numbers (without the ROUND() function) to Number and
select 1 decimal place and only ROUND() the result of the subtraction.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


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