Rounding in If Formula
 

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?

Rounding in If Formula
 

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

=ROUND(A1*0.1,2)

Rick


"Hamed parhizkar" wrote in
message ...
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?