• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IS THIS POSSIBE?

vern07

New Member
65330
I want column E after row 3 to check if column B=PO, if so look in Column D, if blank return with "no promise date", if a date is entered and the date is within 10 days prior to A2 return with "confirm promise date", if column D is 11 days before A2 or greater then nothing. If blank or Req no action.
 
Try,

=IF (and(B4="PO", D4 >= ($A$2-10), D4 <= $A$2), "confirm promise date", IF (and(B4="PO", D4=""), "no promise date", "no action"))

PS: please have a read of the forum rules. Sample file and manually entered solution help us help you better, faster and more efficient. + Title? The correct answer is simply "Yes".
 
adding another twist, keeping everything you already did. Column E look in column A if not blank and column B is blank return "in process". I'm uploading the file this time
 

Attachments

  • test.xlsx
    9 KB · Views: 2
simply add a new IF ( ) before the last false argument.
=IF(AND(B4="PO",D4>=($A$2-10),D4<=$A$2),"confirm promise date",IF(AND(B4="PO",D4>$A$2),"needs expedited",IF(AND(B4="PO",D4=""),"no promise date",IF(B4="return","in process",""))))

Depending of your version of Excel one could use SWITCH ( ) and avoid the IF-nesting.

For further posts: please make your sample data so that it represents all possible scenarios.
 

Attachments

  • test(1).xlsx
    9.4 KB · Views: 0
Back
Top