+ Reply to Thread
Results 1 to 5 of 5

Formula to Calculate Payment Date based on Multiple Conditions

  1. 10-11-2018, 03:56 AM #1
    NonStopLeo
    NonStopLeo is offline
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    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
    Reply With QuoteRegister To Reply
  2. 10-11-2018, 04:30 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-11-2018, 05:41 PM #3
    NonStopLeo
    NonStopLeo is offline
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    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.
    Reply With QuoteRegister To Reply
  4. 10-13-2018, 03:49 PM #4
    NonStopLeo
    NonStopLeo is offline
    Registered User
    Join Date
    03-10-2010
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    68

    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.
    Reply With QuoteRegister To Reply
  5. 10-18-2018, 01:13 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Wish to know the formula to calculate monthly loan payment from fifth payment onward.
    By Elvin Lim in forum Excel Formulas & Functions
    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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1