Home

How to setup an IF function to determine Delivery date is GOOD/NO GOOD

Highlighted
Jose Alas-Ruiz
New Contributor

How to setup an IF function to determine Delivery date is GOOD/NO GOOD

I want to use the IF function to determine if the "delivery date" on cell "B" surpassed the "ship date" on cell "A" by say 1 day, then it's Good, if not, then it's No Good.  In some instances, the delivery date could also be 2 days, e.g., two-day shipment.  This is where I'm getting stuck, how can I tell the excel formula if cell "B" is greater than cell "A" by one day, then Good, if not, No Good. 

2 Replies

Re: How to setup an IF function to determine Delivery date is GOOD/NO GOOD

Jose,

 

You can do it by this simple algorithm:

  • Subtract the Delivery Date from Ship Date.
  • Check if the subtraction value is greater than 1 using this comparative operator ">".
  • Use the above logical test in IF function to return NO GOOD if the logical test is TRUE, and GOOD if the logical test is FALSE.
You can translate the above in this formula:
=IF(B2-A2>1,"No Good","Good")
 
Please find the attached file.

Re: How to setup an IF function to determine Delivery date is GOOD/NO GOOD

Hi Haytham,

 

Thanks so much for the quick response.  It worked beautifully.  

 

Jose,

Related Conversations
Linking OneDrive to New Microsoft Teams Channel
Kelly Charlton in Microsoft Teams on
3 Replies
Adding an Existing OneNote notebook to Teams
CC Adeyemo in Microsoft Teams on
18 Replies
Create private channel in a team
Catalin Prata in Microsoft Teams on
84 Replies