Number Decimal Places Problem

[G Marshall]

Hi There

In cell A1 I have the number .44669, I have formatted this cell to two decimal places hence it displays .45. In cell A2 I have the formula =A1*2 and my answer is displaying .89338. I want cell A2 to display .90 which is the number in cell A1 formatted to two decimal places multiplied by two, but my calculation in cell A2 is using the complete number (.44669) to do the calculation. How do I get around this.

Appreciate any advive

Regards

Gerald

 

[VoG]

Hi. Try

=ROUND(A1,2)*2

 

[G Marshall]

Thanks, that's my problem sorted once again.

Appreciate your help

Gerald