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

%3CLINGO-SUB%20id%3D%22lingo-sub-168389%22%20slang%3D%22en-US%22%3EHow%20to%20setup%20an%20IF%20function%20to%20determine%20Delivery%20date%20is%20GOOD%2FNO%20GOOD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168389%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20use%20the%20IF%20function%20to%20determine%20if%20the%20%22delivery%20date%22%20on%20cell%20%22B%22%20surpassed%20the%20%22ship%20date%22%20on%20cell%26nbsp%3B%22A%22%20by%20say%201%20day%2C%26nbsp%3Bthen%20it's%20Good%2C%20if%20not%2C%20then%20it's%20No%20Good.%26nbsp%3B%20In%20some%20instances%2C%20the%20delivery%20date%20could%20also%20be%202%20days%2C%20e.g.%2C%20two-day%20shipment.%26nbsp%3B%20This%20is%20where%20I'm%20getting%20stuck%2C%20how%20can%20I%20tell%20the%20excel%20formula%20if%20cell%20%22B%22%20is%20greater%20than%20cell%20%22A%22%20by%20one%20day%2C%20then%20Good%2C%20if%20not%2C%20No%20Good.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-168389%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168412%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20setup%20an%20IF%20function%20to%20determine%20Delivery%20date%20is%20GOOD%2FNO%20GOOD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168412%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Haytham%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20so%20much%20for%20the%20quick%20response.%26nbsp%3B%20It%20worked%20beautifully.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJose%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168404%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20setup%20an%20IF%20function%20to%20determine%20Delivery%20date%20is%20GOOD%2FNO%20GOOD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168404%22%20slang%3D%22en-US%22%3E%3CP%3EJose%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20do%20it%20by%20this%20simple%20algorithm%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESubtract%20the%26nbsp%3B%3CSTRONG%3EDelivery%20Date%3C%2FSTRONG%3E%20from%26nbsp%3B%3CSTRONG%3EShip%20Date%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3ECheck%20if%20the%20subtraction%20value%20is%20greater%20than%201%20using%20this%20comparative%20operator%20%3CSTRONG%3E%22%26gt%3B%22%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3EUse%20the%20above%20logical%20test%20in%20%3CSTRONG%3EIF%20function%3C%2FSTRONG%3E%20to%20return%20%3CSTRONG%3ENO%3C%2FSTRONG%3E%20%3CSTRONG%3EGOOD%20%3C%2FSTRONG%3Eif%20the%20logical%20test%20is%20%3CSTRONG%3ETRUE%3C%2FSTRONG%3E%2C%20and%20%3CSTRONG%3EGOOD%3C%2FSTRONG%3E%20if%20the%20logical%20test%20is%20%3CSTRONG%3EFALSE%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CDIV%20class%3D%22g-unit%22%20id%3D%22gt-res-c%22%3E%0A%3CDIV%20id%3D%22gt-res-p%22%3E%0A%3CDIV%20id%3D%22gt-res-data%22%3E%0A%3CDIV%20id%3D%22gt-res-wrap%22%3E%0A%3CDIV%20id%3D%22gt-res-content%22%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20id%3D%22gt-res-dir-ctr%22%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EYou%20can%20translate%20the%20above%20in%20this%20formula%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20dir%3D%22ltr%22%3E%0A%3CPRE%3E%3DIF(B2-A2%26gt%3B1%2C%22No%20Good%22%2C%22Good%22)%3C%2FPRE%3E%0A%3C%2FDIV%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20dir%3D%22ltr%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EPlease%20find%20the%20attached%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

3 Replies

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.

Hi Haytham,

 

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

 

Jose,

@Haytham Amairah I have a question, how would you modify this formula if you have multiple carriers in one workbook? I have 4 different carriers all lumped into one workbook but what to find the percentages for each.