+ Reply to Thread
Results 1 to 2 of 2

Complex If then Conditional formula

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    Chicagoland
    Posts
    5

    Complex If then Conditional formula

    I have been trying to build a conditional formula and I cannot get it right. The formula will look at a single status column and based upon the status display various results. I am including a copy of what I am trying to create with the desired results displayed.

    1) If complete status = D the formula result should return a status of Verify, If Complete Status = C the formula should return the word Disburse, if the complete status = A the formula should count the number of days between the receipt date and the current date, if the sum of days calculated is 0-44 days the formula result should display Place, if the sum of days is 45-59 the formula result should display Nearing overage,place or return, if the sum of days calculated is > 60 and the quantity for material code starting with any letter; A, B C, D, K or 1 is <299 in the quantity available field the formula result should display Junk, if the sum of days calculated is > 60 and the quantity for material code starting with any letter; A, B C, D, K, or 1 is >299 in the quantity available field the formula result should display Return for credit. if the sum of days calculated is > 60 and the quantity available field for material code starting with a number; 5 is <999 in the quantity available field the formula result should display Junk, if the sum of days calculated is > 60 and the quantity for material code starting with a number: 5 is >999 the formula result should display Return for credit.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Complex If then Conditional formula

    I couldn't quite get your example to match up with the description but the following user defined function may help.

    Please Login or Register  to view this content.
    Open up the VBA editor by hitting ALT F11

    Insert a new module by hitting Insert - Module

    Paste the function macro into the empty sheet

    Hit ALT F11 to get back to the worksheet.

    Enter

    Please Login or Register  to view this content.
    in J2
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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