+ Reply to Thread
Results 1 to 3 of 3

Simple formula using IF and SUM - yields unexpected error

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    NYC, NY
    MS-Off Ver
    excel 2007
    Posts
    4

    Simple formula using IF and SUM - yields unexpected error

    Hello,
    Using this formula for a bank account,
    =IF(SUM(C2-A1+B1)=C1, "match", "NO match")
    down a column of about 3000 rows,
    yields only one cell with an unexpected and probably incorrect response in G2 with a "NO Match" - where the math is correct ?

    Can someone please explain - I'm curious as to why this happens.
    Thank you kindly,

    A B C D
    63.58 0.00 -54.97 match
    64.57 0.00 8.61 NO match
    128.21 0.00 73.18 match
    201.39

    Details:
    Attachment is included;
    temp2.xlsx

    in a bank account file, where "C2" is the previous balance, "C1" is the current balance,
    "A1" is any check written, "B1" is any deposit applied.
    Last edited by Frankie7; 04-25-2014 at 08:53 PM. Reason: typo

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Simple formula using IF and SUM - yields unexpected error

    This is an error that kreeps in from time to time. If you break down your formula to its basic part (you dont need to use SUM() for this)...=F3-D2+E2 press F2 and then F9, you will see the answer is 8.61000000000001

    Change your formula to this, copied down...
    =IF(ROUND(F2-D1+E1,4)=ROUND(F1,4), "match", "NO match")

    Round to however many decimals you feel will give you what you need
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-26-2011
    Location
    NYC, NY
    MS-Off Ver
    excel 2007
    Posts
    4

    Re: Simple formula using IF and SUM - yields unexpected error

    Resolved.
    Huh, didn't expect Microsoft to have a error - LOL.
    Glad to know it's not me this time.
    Thank you Mr. Moderator.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help please... Simple calculation - with unexpected results
    By MLK in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2006, 07:10 PM
  2. [SOLVED] Excel 2007 MS Query prompt yields Syntax error
    By Bruce in forum Excel General
    Replies: 0
    Last Post: 05-26-2006, 06:10 AM
  3. New to VBA, getting unexpected error 1004
    By Teodomiro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2006, 11:50 AM
  4. 6th order polynomial equ yields unexpected results
    By Sanjay Kumar Limbikai in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-26-2005, 08:05 PM
  5. [SOLVED] ACCRINT formula yields incorrect result
    By Onurali_k in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2005, 02: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