Rounding in If Formula

[Hamed parhizkar]

I am making a formula to copy and paste from excel and post it into an
accounting application, I ran into a problem that I need help with.


It is a rounding problem. For instance in Cell A1 I have 106.12

So in A2 my formula reads... =A1*.1

The output is 10.612

I know I can adjust the number to show after the decimal but the number is
truly still there.

Here is what I run into.. I have a formula that reads... =if(A1<>0,A2,"")

But I cant have 3 numbers after the decimal, because when I copy and paste
it into my application it reads 3 places after the decimal even though
cosmetically it is not there....

Can someone please help me?

 

[Rick Rothstein \(MVP - VB\)]

What about using this formula instead of your =A1*.1 formula?

=ROUND(A1*0.1,2)

Rick