Math Calculation
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
|