I have a formula as follows:
C1=A1*B1 (assume A1=$482,933 and B1=0.9695)
My expected result is $468,203. However the actual result shown in C1 is
$468,181.
It appears as though the value used in B1 to derive the result is accurate
to a greater precision (i.e. 0.9695?????) than the 4 decimal places displayed
in cell B1.
Is there a way I can force the formula to use a specfic precision or some
other solution to my porblem?
TIA. Chris.