# Formula to Calculate Payment Date based on Multiple Conditions

1. ## Formula to Calculate Payment Date based on Multiple Conditions

Hi Friends
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.

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

2. ## 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?

4. ## Re: Formula to Calculate Payment Date based on Multiple Conditions

Hi Friends
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

5. ## 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.

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

#### 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