ROUND - formatting

[thetallguy0]

A1 10.404

B1 2

A2 £10.40 =ROUND(A1,2)

B2 £10.404

C2 £10.40 =IF(B1=2,A2,if(b1=3,B2,""))



In the above scenario I cannot get the right result in c2. With 2 decimal places I get 10.400 (because of the 3 decimal place formatting of c2). If I format c2 to 2 places I cannot display the result of 3 places when I need it.

If I use TRUNC, the 0 always drops off 10.40.

Any ideas please.

I posted this before and thought I had the answer but it is not working and the problem is still between the chair and the keyboard.

[shg]

Format C2 as General.

And perhaps you could change the formula in C2 to =ROUND(A1, B2)