Forum Discussion
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.
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.
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.
Hi Haytham,
Thanks so much for the quick response. It worked beautifully.
Jose,
