+ Reply to Thread
Results 1 to 5 of 5

Formula to Calculate Payment Date based on Multiple Conditions

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    64

    Formula to Calculate Payment Date based on Multiple Conditions

    Hi Friends
    I need your help again..
    In attached sheet, I am trying to enter a formula in column L on the basis as below:
    If column I is less than 3, then leave Column L blank
    If column I is => 3, then if column B is <= 3, then vlookup "3" from Column B against Same Month sales in column C and return the value in Column L
    If column I is => 3, then if column B is > 3, return the same value of column G of same row.

    In attached sheet, In column L I have entered formula, it is giving some correct result and somewhere it is showing wrong results. I have mentioned my remarks in column M to describe that what is the desired results against each row.

    Kindly check and help me to rectify the formula is column L.

    Thanks in Advance.

    =======================
    Question is also posted on below link but no response.
    https://www.excelguru.ca/forums/show...ple-Conditions
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,508

    Re: Formula to Calculate Payment Date based on Multiple Conditions

    The post on the other forum has only been there for two hours. You seem to be very impatient. Do you understand the nature of these forums? That is, you are getting help for FREE from volunteers?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Formula to Calculate Payment Date based on Multiple Conditions

    Can Anyone please help me on this problem? I am really stuck due to this.

  4. #4
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Formula to Calculate Payment Date based on Multiple Conditions

    Hi Friends
    I am stuck with my formula, if anyone can please help me to find the solution.
    The formula I have entered is working only if column D (Delivery Date) is sorted, but my real data is unsorted in most of the cases, so if can please help me to reach a solution. It would be great help
    Thanks in advance.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,508

    Re: Formula to Calculate Payment Date based on Multiple Conditions

    Issue solved on the other forum.

    Leo - given that you have cross-posted, we expect you to have the courtesy to tell us if you get a solution elsewhere so that members' time here is not wasted.

    Thread marked as solved.

+ 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. Calculate total based on multiple conditions
    By antonywijesinghe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2018, 02:57 AM
  2. [SOLVED] Calculate Next Payment Date based on multiple criteria
    By sabin348 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2015, 07:27 AM
  3. formula to subtract payment amount on monthly payment date
    By restingdonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 03:39 PM
  4. Replies: 3
    Last Post: 07-29-2013, 11:31 AM
  5. Calculate Values based on Multiple Conditions
    By creativefusion in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-24-2009, 09:27 PM
  6. create a formula to look to calculate average payment based on rep and date
    By EddieMaher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2008, 03:55 PM
  7. [SOLVED] calculate payment with first payment due date variable?
    By Jody Solbach in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2005, 12:46 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