Mar 06 2018 10:16 AM
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.
Mar 06 2018 10:49 AM - edited Mar 06 2018 10:51 AM
Jose,
You can do it by this simple algorithm:
=IF(B2-A2>1,"No Good","Good")
Mar 06 2018 11:12 AM
Hi Haytham,
Thanks so much for the quick response. It worked beautifully.
Jose,
Jul 28 2021 02:50 PM
@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.