+ Reply to Thread
Results 1 to 2 of 2

IF/OR for Aging Report

  1. #1
    Registered User
    Join Date
    06-10-2010
    Location
    Chicago, IL, USA
    MS-Off Ver
    Excel 2013
    Posts
    19

    Unhappy IF/OR for Aging Report

    I am trying to build a formula for my aging report that will work with conditional formatting. If an invoice is still unpaid, I want the # of days past due; that part I have down. If an invoice has been paid (noted in a separate column), I don't want to delete it off of the report, I just want it to have PAID in the Days Past Due column. My conditional formatting is based on the number in the Days Past Due column.

    I'm pretty sure I need to use an IF/OR nesting function, but I'm not getting the syntax right. It's all starting to blur together at this point. (I've spent the past hour + reading through various threads to see if this has been addressed already and there are a few threads that were close, but nothing that was 100%.)

    My final attempt before my cry for help: =IF(AND(ISBLANK(K73),(=DAYS($B$1,G73)),IF(AND(K73="YES","PAID",)

    Sample Aging Report.xlsx
    Catt33
    Chicago

  2. #2
    Forum Contributor
    Join Date
    06-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    142

    Re: IF/OR for Aging Report

    What if you changed your formula to:

    Please Login or Register  to view this content.
    If you have the word "YES" in column K, then this would put "PAID" in Column H, otherwise, it will calculate days since due.
    Last edited by jjhayes; 12-04-2014 at 04:06 PM. Reason: fixed typo in formula

+ 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. Aging report
    By GHORT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2012, 05:47 PM
  2. Aging Report
    By bkj2010 in forum Excel General
    Replies: 3
    Last Post: 09-27-2011, 06:42 AM
  3. [SOLVED] Aging Report
    By relats in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-08-2011, 03:50 AM
  4. aging report
    By galarza in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-13-2009, 07:25 AM
  5. Aging report
    By SABRINA7 in forum Excel General
    Replies: 9
    Last Post: 12-05-2008, 11:14 PM

Tags for this Thread

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