Results 1 to 9 of 9

Thread: Formula to Calculate Payment Date based on Multiple Conditions

  1. #1
    Seeker NonStopLeo's Avatar
    Join Date
    Oct 2018
    Posts
    5
    Articles
    0
    Excel Version
    2016

    Formula to Calculate Payment Date based on Multiple Conditions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Friends
    I am new to this forum and need your help.
    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.
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,057
    Articles
    0
    Excel Version
    Office 365 Subscription
    I notice that you have a history of cross-posting: if you have already asked this question elsewhere, you need to tell us and provide a link or links to those other places. Generally speaking, the membership is reluctant to help serial cross-posters who just seem to continue ignoring forum rules. The rules on this are the same everywhere: don't get yourself banned.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,057
    Articles
    0
    Excel Version
    Office 365 Subscription
    There are at least two other forums where you have cross-posted, and on one of them, your thread has been closed for failing to mention this thread. You need to provide links to both forums here. If you don't, then this thread will be closed, too.
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Seeker NonStopLeo's Avatar
    Join Date
    Oct 2018
    Posts
    5
    Articles
    0
    Excel Version
    2016
    @AliGW
    Thanks for pointing towards forum rules regarding cross posting.
    However, kindly let me give my clarification about it.
    I am a professional person and I do respect forum rules and experts who are providing their services as volunteers. Thanks to all of them for putting their efforts in solving our problems.
    Regarding cross-posting, this specific question was posted on excel guru first, and later on posted on excelforum so I also mentioned link of this thread in excelforum. but later on when I tried to add excelforum link in this thread, I could not find the option to edit this thread as it was already posted as first & original question.

    Regarding the other thread on Mrexcel/excelforum (cross links posted on both forums) had a different question which was posted a week ago, but due to no solution on any forum, I tried to solve it myself for a week and was stuck at last point which I asked in this thread posted on excelguru/excelforum.

    Anyways, excelforum link I am providing here.
    https://www.excelforum.com/excel-for...ml#post4987011

    Sorry for all this. I would be more careful about rules of forum. Thank You again as well.

  5. #5
    Seeker NonStopLeo's Avatar
    Join Date
    Oct 2018
    Posts
    5
    Articles
    0
    Excel Version
    2016
    Hi
    Here is the link of same question posted on another forum. Thanks
    https://www.excelforum.com/excel-for...ml#post4989548

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    791
    Articles
    0
    Excel Version
    2010
    Hello there...
    Try this in L6, copied down:
    =IFERROR(IF(OR(D6="",E6="Cancelled",I6<=2),"",EOMONTH(IF(B6>=3,D6,(MAX(INDEX(($C$6:$C$28=C6)*($B$6:$B$28=3)*$D$6:$D$28,0)))),0)+1),"")

    Hope that helps

  7. #7
    Seeker NonStopLeo's Avatar
    Join Date
    Oct 2018
    Posts
    5
    Articles
    0
    Excel Version
    2016
    @Hercules1946
    Thank you for the solution. After few modifications, it is giving desired results. You are really magician
    Can anyone please mark the thread - SOLVED?

  8. #8
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,057
    Articles
    0
    Excel Version
    Office 365 Subscription
    There is no solved tag available on this forum.
    Ali
    Enthusiastic self-taught user of MS Excel!

  9. #9
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    791
    Articles
    0
    Excel Version
    2010
    Glad to be of help. Thanks for the feedback

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •