| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why does a formula not total right?
I have say =sum(E1+G3)
E1 = $10.00 G3 = 8 The cell I put this formula in comes up (2 or 3) cents off. This does not happen all the time but off & on. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
why does a formula not total right?
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind regards, Niek Otten "Kickstart" wrote in message ... I have say =sum(E1+G3) E1 = $10.00 G3 = 8 The cell I put this formula in comes up (2 or 3) cents off. This does not happen all the time but off & on. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
why does a formula not total right?
Sounds like one of the cells contains the small cents values but they don't
show because of formatting..... hth Vaya con Dios, Chuck, CABGx3 "Kickstart" wrote: I have say =sum(E1+G3) E1 = $10.00 G3 = 8 The cell I put this formula in comes up (2 or 3) cents off. This does not happen all the time but off & on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to sum total numbers with dashes in them | Excel Discussion (Misc queries) | |||
| Formula to add top 4 entries in a column and total them at the bot | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| highlight cells to obtain total without using formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
