+ Reply to Thread
Results 1 to 8 of 8

Aging calculate with column a or b depends upon condition

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Aging calculate with column a or b depends upon condition

    Dear expert

    i have aging formula to calculate with a or b depends upon condition of a and b column.

    I have column in column a and b i want aging depends upon cell value below....

    If a column is blank then take aging with b
    if b column is blank then take agin with a
    if a & b both column is blank result not found
    if a & b column have date i want calculate aging with latest date.

    Find the attachment

    you may get understand@!!!!!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,618

    Re: Aging calculate with column a or b depends upon condition

    Put this formula in C2 and copy down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 09-03-2013 at 04:34 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,108

    Re: Aging calculate with column a or b depends upon condition

    Hello breadwinner,

    And for Column D you could use: =IF(AND(A2="",B2=""),"Not Found",IF(A2 > B2,A2, B2))
    provided you have Columns A & B correctly formatted, as I have done for you in the attached Workbook.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Re: Aging calculate with column a or b depends upon condition

    DUDE
    ITS WORKING PERFECTLY

    =IF(COUNT(A2:B2)=0,"NOT FOUND",LOOKUP(TODAY()-MAX(A2:B2),{0,3,6,11,21,31},{"1-2","3-5","6-10","11-20","21-30",">30"})&" Days")

    IF I ENTER THE FUTURE EITHER A OR B I WANT RESULT IN - MINUS IF A COULMN 02-09-2013 AND B 07-09-2013 RESULT -0-2 DAYS

    CAN U MAKE CHANGES
    Last edited by breadwinner; 09-03-2013 at 05:53 AM. Reason: EXPLANATION

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,618

    Re: Aging calculate with column a or b depends upon condition

    Quote Originally Posted by breadwinner View Post
    DUDE
    ITS WORKING PERFECTLY

    =IF(COUNT(A2:B2)=0,"NOT FOUND",LOOKUP(TODAY()-MAX(A2:B2),{0,3,6,11,21,31},{"1-2","3-5","6-10","11-20","21-30",">30"})&" Days")

    IF I ENTER THE FUTURE EITHER A OR B I WANT RESULT IN - MINUS BUT HERE SHOWS N/A

    CAN U MAKE CHANGES
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 09-03-2013 at 05:59 AM.

  6. #6
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Re: Aging calculate with column a or b depends upon condition

    DUDE I WANT SAME RESULT LIKE IN AGING FORMAT -(0-2 Days)

    example if A have 01-09-2013 B have 05-09-2013 so here B have greater than today date so formula has to take 05-09-2013 for aging result i want how many days range of aging from today date, result -(0-2 Days) or -3-5 Days or -6-10 Days or -11-20Days or -21-30 Days or >30 Days...if it A OR B cross today date RESULT in agint with minus

    sorry for tro

  7. #7
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,618

    Re: Aging calculate with column a or b depends upon condition

    YOU'RE WELCOME...DUDE

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    584

    Re: Aging calculate with column a or b depends upon condition

    Perfect It works 100% Dude You are Alpha for excel....Thanks alot

+ 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. [SOLVED] require if condition formula depends upon 3 column result either success or fail
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2013, 02:01 AM
  2. condition formula result from depends upon 3 cell values with conditions
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2013, 07:15 AM
  3. If condition for dates in range result depends upon changes of date
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2013, 08:26 AM
  4. Replies: 10
    Last Post: 12-22-2010, 07:06 AM
  5. shift cells down depends on condition of others
    By drawing.blanks in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2009, 12:01 AM

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