Here's my problem: I have two cells and a resulting cell. See below:
Cell 1 Cell 2 Cell 3
$1.10 $1.43 $2.52

When I open up the formatting to 3 decimal places, it looks like this:
Cell 1 Cell 2 Cell 3
$1.097 $1.428 $2.525

The math is right; but how do I get Cell 3 to show 2.53 and not 2.52?

-- TIA
Jan

=ROUND(A1+B1,2)

--
Gary''s Student - gsnu200805

Jan ... Are you sure you want to do this?

$2.525 ... is probably rounding up from $2.52? ... Set format to more
decimals to see what Excel is really doing ... I am thinking $2.52 is correct
for cell 3???

Kha

"Jan" wrote:

Here's my problem: I have two cells and a resulting cell. See below:
Cell 1 Cell 2 Cell 3
$1.10 $1.43 $2.52

When I open up the formatting to 3 decimal places, it looks like this:
Cell 1 Cell 2 Cell 3
$1.097 $1.428 $2.525

The math is right; but how do I get Cell 3 to show 2.53 and not 2.52?

-- TIA
Jan

Ultimately, the math is correct.
However, cells 1 and 2 are rounding to the nearest 100th; but cell 3 is not.
Why not?
--
Jan


"Ken" wrote:

Jan ... Are you sure you want to do this?

$2.525 ... is probably rounding up from $2.52? ... Set format to more
decimals to see what Excel is really doing ... I am thinking $2.52 is correct
for cell 3???

Kha

"Jan" wrote:

Here's my problem: I have two cells and a resulting cell. See below:
Cell 1 Cell 2 Cell 3
$1.10 $1.43 $2.52

When I open up the formatting to 3 decimal places, it looks like this:
Cell 1 Cell 2 Cell 3
$1.097 $1.428 $2.525

The math is right; but how do I get Cell 3 to show 2.53 and not 2.52?

-- TIA
Jan

What happens if you go to 4 decimals? I bet cell 3 is 2.524... and properly
rounding to 2.52. Use of rounding as Gary's Student suggests would solve
your problem. I'd round the calculations for Cell 1 and Cell 2 and add them
for Cell 3.



"Jan" wrote:

Ultimately, the math is correct.
However, cells 1 and 2 are rounding to the nearest 100th; but cell 3 is not.
Why not?
--
Jan


"Ken" wrote:

Jan ... Are you sure you want to do this?

$2.525 ... is probably rounding up from $2.52? ... Set format to more
decimals to see what Excel is really doing ... I am thinking $2.52 is correct
for cell 3???

Kha

"Jan" wrote:

Here's my problem: I have two cells and a resulting cell. See below:
Cell 1 Cell 2 Cell 3
$1.10 $1.43 $2.52

When I open up the formatting to 3 decimal places, it looks like this:
Cell 1 Cell 2 Cell 3
$1.097 $1.428 $2.525

The math is right; but how do I get Cell 3 to show 2.53 and not 2.52?

-- TIA
Jan