Calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: tkosel (tkosel_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 14:13:01 -0700

This is actually my second post, I neglected to show the data I was asking
about.

If i have the following data in a worksheet (first 20 rows), it yields the
sum calculation in row 21. How can that be? How can it have more resolution
than the source data. I expect it to be zero. (Obviously i have displayed
more decimals in row 21 than the others.)

-0.00635
-0.0437
-0.0092
0.0276
0.0115
-0.05175
0.0805
-1.14955
1.2742
0.06925
-0.277
0.9695
-0.59555
-0.0762
0.0254
-0.1016
-0.17145
0.508
-0.48475
0.00115
-0.000000000000000095409791178724

Relevant Pages

  • Re: Little Problem, Difficult and Hard.
    ... First select the worksheet your data reside and then run the macro below. ... Dim rng As Range, Unirng As Range, id As Range ... Set dstsh = Worksheets) ... I want to have only the data that matches the condition without having any zero as a result. ...
    (microsoft.public.excel.programming)
  • Re: Zero replaces blank field when paste special is used
    ... Paste Link creates formulas that point back to the original worksheet. ... contain data) and the fields are indeed empty. ... same zero as previously reported. ... Am I correct in my assumption that a cell is empty if after selected, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hide rows with zero balances
    ... All columns must have a zero. ... how do I get the macro to run across all ... Alt + F11 (open VBE) ... new worksheet as such: Account Name, Account Number, Dr & Cr. ...
    (microsoft.public.excel.misc)
  • Re: Copying Worksheets
    ... If a formula evaluates to zero but the zero doesn't display it would seem ... The saved worksheet is working properly ... | regards to formulas, leaving cells blank, etc. ...
    (microsoft.public.excel.misc)
  • Re: Recognise filter in macro and ignore.
    ... If you are moving data to a new worksheet for printing, ... before moving it, and skip those records that you do not want to print. ... "malycom" wrote in message ... some of the values may be zero. ...
    (microsoft.public.excel.programming)