Subtracting Rounded Numbers

[Guest]

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?

 

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

I am using the ROUND( ) formula after subtracting the two figures.

 

[joeu2004]

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?

I am using the ROUND( ) formula after subtracting the two figures.

It sounds like you want to subtract 1.6 from 4.0 (i.e. the rounded
values), resulting in 2.4, instead of subtracting 1.55 from 4.0 (i.e.
the unrounded values), resulting in 2.5 after rounding. Right?

Two ways come to mind:

1. Instead of ROUND(A1-B1,1), use ROUND(A1,1) - ROUND(B1,1).

2. Select the option Tools => Options => Calculation => Precision As
Displayed.

The problem with #2 is: it affects the entire workbook. There are
many times when that is undesirable.

PS: Forgive me if I misinterpreted your intentions. You really are
not expressing yourself very well.

First, you say that A1 and B1 __each__ use ROUND(). If that is the
case, A1 is actually 1.6. So how could you subtract 1.55 in C1? On
the other hand, you do say "formatted using ROUND", which is
ambiguous. Could you mean that A1 (and B1?) is round by selecting
Format => Cells => Number => Number with 1 decimal places?

Instead of __describing__ what you have in English, which is
inherently ambiguous, I suggest that you post the __actual__ formulas
and formats that you have in A1, B1 and C1, and __carefully__ explain
what result you see now and what alternate result you prefer to see,
given the example values.

 

[iliace]

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