Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding in Excel
I have a table that has numbers "hard coded" back to another spreadsheet in
the workbook. Excel says that the numbers (961+73-60=974) in the table. However, entered separately without decimals, Excel says (961+73-60=975). I am concerned that wehn people read my table, they will see that the numbers don't add up. Is there any way short of re-entering whole numbers to solve this problem. Thanks in advance. Al Charbonneau |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding in Excel
Bit confusing; we need more info
What formula are you using? What at eh numbers on the other sheet? You say "However, entered separately without decimals, Excel says (961+73-60=975)" This is clearly wrong (1+3-0 = 4) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Al Charbonneau" <Al wrote in message ... I have a table that has numbers "hard coded" back to another spreadsheet in the workbook. Excel says that the numbers (961+73-60=974) in the table. However, entered separately without decimals, Excel says (961+73-60=975). I am concerned that wehn people read my table, they will see that the numbers don't add up. Is there any way short of re-entering whole numbers to solve this problem. Thanks in advance. Al Charbonneau |
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 | |||
Rounding in Excel | Excel Worksheet Functions | |||
ROUNDING IN EXCEL | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding in Excel | Excel Discussion (Misc queries) |