Results 1 to 4 of 4

(A - B) is not equal to A - B, apparently

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2016
    Location
    London, UK
    MS-Off Ver
    2016
    Posts
    31

    (A - B) is not equal to A - B, apparently

    So in cell A1 have the following formula:

    A1 =SUM(AE10:AP10)-O10, which returns 0. O10 is yearly revenue, cells AE to AP are monthly revenues, which are calculated on the basis of $O$10/12, so it's normal that I get 0 in A1. I double-check by doing B1 = A1 = 0, which gives me TRUE.

    However, when I do A1 =(SUM(AE10:AP10)-O10) [so with brackets], suddenly B1 = A1 = 0 gives me FALSE. Any idea why that might happen?

    Thanks!
    EG

    Also asked the above question here: http://www.mrexcel.com/forum/excel-q...ml#post4439839
    Last edited by edward_glyver; 02-24-2016 at 08:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Empty Cells apparently have spaces
    By Sam Capricci in forum Access Tables & Databases
    Replies: 13
    Last Post: 03-02-2015, 12:55 PM
  2. One column is apparently over 200 data series
    By QuartzGeode in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-28-2013, 05:35 AM
  3. Replies: 2
    Last Post: 07-02-2013, 02:43 PM
  4. My logic is is illogical, apparently.
    By NoSo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2013, 01:57 AM
  5. I need help with a (apparently) very simple VBA script
    By profbosco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2006, 07:10 PM
  6. My needs are simple-apparently, so am I
    By LSUCHEER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2005, 03:05 PM
  7. [SOLVED] Apparently Simple Question
    By exceller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2005, 01:06 PM

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