Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS | Excel Worksheet Functions |