Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I put in =sum(E1+G23) & the total in the cell where I put the formula comes
up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the time but off & on. I have to add stuff on paper to check that the total is right. I should not have to take all this time to use Excel. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Your question has already been answered an hour and a half ago
-- Kind regards, Niek Otten "Kickstart" wrote in message ... I put in =sum(E1+G23) & the total in the cell where I put the formula comes up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the time but off & on. I have to add stuff on paper to check that the total is right. I should not have to take all this time to use Excel. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Check out
http://www.mcgimpsey.com/excel/pennyoff.html Note that you don't need the SUM() functions. =E1+G23 =E1*G23 work the same way. In article , Kickstart wrote: I put in =sum(E1+G23) & the total in the cell where I put the formula comes up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the time but off & on. I have to add stuff on paper to check that the total is right. I should not have to take all this time to use Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |