LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

That's the reason, see RD's link

--
Regards,

Peo Sjoblom


"KimberlyC" wrote in message
...
The numbers are a result of a formula...
The formula is (for H8) G8/365


"RagDyeR" wrote in message
...
Are these numbers in H8:H13 the results of formulas, or did you key them

in
manually, where you can select the individual cells and see the actual
number in the formula bar.

I'll bet this is a rounding issue.

See this link of John McGimpsey:

http://www.mcgimpsey.com/excel/pennyoff.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"KimberlyC" wrote in message
...
Hi
I have the following numbers in H8:H13:
1.000
1.000
0.088
0.751
0.252
1.000

When I add these up in cell H7, using =Sum(H8:H13), the answer is 4.090.
It should be 4.091
Why is this happening....and how can I stop it from doing that or how can

I
adjust my formula to make it add these numbers correctly?
Thanks in advance for your help!!

Kimberly :)






 
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
In MS Excel, how do I change the column ref headers from numbers . Bruce Lindfield Excel Discussion (Misc queries) 2 July 31st 08 12:30 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Average of numbers in column between to other numbers Ditandhischeese Excel Discussion (Misc queries) 2 March 31st 05 03:35 AM
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA Excel Worksheet Functions 4 February 23rd 05 09:19 PM


All times are GMT +1. The time now is 05:55 PM.

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"