| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
| formula for rounding | Excel Programming | |||
Hybrid Mode
