Results 1 to 4 of 4

Simple formula returning odd result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2005
    Posts
    108

    Simple formula returning odd result

    Hi all

    I have a reasonable grasp of Excel and this has me completely stumped.

    Three cells hold numeric values (format General though the format seems not to change the result)

    C4 = 4082322.25
    D4 = 4046689.05
    E4 = 35633.2

    Another cell contains the simplest of formulae ...
    F4 = "=C4-D4-E4"

    Clearly the result should be zero.
    In fact the result is (to 15 decimals) ...

    0.000000000189175

    HOWEVER
    If I change F4 formula to "=C4-E4-D4" the result is zero.

    Any ideas
    Last edited by tonywig; 06-10-2009 at 07:38 AM.
    Tony

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1