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?
Please find solution of this and Calculate conditional and distribution probability

Hello,

The presentation of the numbers regarding rounding digits is this way:
[MATH=eng]a←mat(23.305,23.315,23.325,23.335,23.345,23.355,23.365,23.375,23.385,23.395,10,1)[/MATH] [MATH=eng]a=mat(23.3,23.32,23.32,23.34,23.34,23.36,23.36,23.38,23.38,23.4,10,1)[/MATH]

This is only used in the presentation. The values are not actually rounded. They still have the same values as defined. If you want to do the rounding to 2 decimal places - to change the values, here is the result:

[MATH=eng]for(i,range(1,length(a)),el(ar,i)←round(el(a,i),2))[/MATH]
[MATH=eng]ar=mat(23.31,23.32,23.33,23.34,23.35,23.36,23.37,23.38,23.39,23.4,10,1)[/MATH]

Regards,
Radovan