Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 419
Default sum of cells

Tricia,

Probably not. Remember that the value of a cell and what it displays are
not alwasy the same. What is showing in the cell could be rounded up from
the actual value. And what you are adding on the calculator is probably
what is displayed.

If these cells are not fomulas, click on each cell and look in the formula
bar to see its actual value. If they are fomulas, copy the cells and paste
special as values in unused cells off to the side and then check their
values.

If you are working with decimal values, run the decimal places out 2, 3, 4,
or more decimal places then it is already set at.

HTH,

Conan




"Tricia" wrote in message
...
When I get the sum of 10 cells it comes up 2 cents short of what it should
be
when checked on the calculator. Is this a bug?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
display a range of cells editible cells based on matching date Miki Excel Worksheet Functions 0 October 10th 07 03:27 PM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
paste locked cells and unlocked cells in protected sheet Angeline Excel Worksheet Functions 15 November 1st 06 11:51 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"