| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why are my columns not adding correctly
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..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why are my columns not adding correctly
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "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..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why are my columns not adding correctly
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..... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why are my columns not adding correctly
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..... |
|
#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..... |
| Reply |
| 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 | |||
Hybrid Mode
