| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why are my columns not adding correctly
Use =Round(YourFormula,2), then sum.
-- Regards, Fred "Cathie" wrote in message ... Thank you, but how do I correct the rounding up? "S S" wrote: It could be the formatting of the cells, with some rounding up taking place. "Cathie" wrote in message ... I am new to excel, and am using a spreadsheet alreadey set up, when I have two cells to add up, the total is off by 1 penny, why? Formula says =Sum(F2:G2) help..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row of numbers not adding correctly | Excel Discussion (Misc queries) | |||
| Numbers not adding together correctly | Excel Worksheet Functions | |||
| adding days correctly | Excel Worksheet Functions | |||
| numbers not adding up correctly in spreadsheet | Excel Worksheet Functions | |||
| numbers not adding up correctly in spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
