Results 1 to 2 of 2

IF statement with 3 conditions for Reconciliation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    372

    IF statement with 3 conditions for Reconciliation

    In the attached file, I'm trying to match the IF statement with the 3 conditions below. I have only managed 2 but can't figure out the 3rd one... formula in in the RECON table



    Three Conditions:
    If both months totals match, than equal YES
    If month "BEFORE" is X total and month "AFTER" is ZERO, than NO
    IF both mohths equal ZERO, than equal N/A
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Statement for 3 different conditions
    By Sgligori in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-17-2015, 03:49 PM
  2. Conditions with an IF statement
    By z941714 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2015, 04:16 PM
  3. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  4. 3 Conditions for an IF Statement
    By Rocksteady in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2013, 07:38 AM
  5. [SOLVED] A Bank Statement Reconciliation template
    By slidergirl1 in forum Excel General
    Replies: 1
    Last Post: 07-22-2006, 03:50 PM
  6. Conditions with IF statement
    By Jaydubs in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 12:50 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