Multiple conditions

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Struggling with writing two or more "if" statements, then returning one value
if a match, another if not. Here's my worksheet:

A B C D E F
1 10 14
2
3 3-15 3-25 X
4 3-15 3-29 Y
5 3-15 3-16 3-30 Y

Column A is a planned ship date, column B is an actual ship date, column C
is the expected receipt date, column D is the shipping site.
E1 and F1 are transit days

What I need to calclulate in cell column C is:
If B3 is "", and D3 is X, then A3+E1, but if B3 is >0, then B3 +E1,
and
If B3 is "", and D3 is Y, then A3+E1, but if B3 is >0, then B3 +F1,


Thanks!!
Don
 
Hope my solution works for you, but i have some questions. Is your E1 and F1
fixed, as in no matter how long your list is in column A,B,D it will always
make use of E1 and F1? Another question I have is suppose I am looking at row
4, since B4 is "" and D4 is Y, then should it not be A4+E1 which should
return 3-25 instead of 3-29 in your example?

Try this in your C3
=IF(AND(B3<>"",D3="Y"),B3+$F$1,IF(AND(B3="",D3="Y"),A3+$E$1,IF(AND(B3="",D3="X"),A3+$E$1,B3+$E$1)))

Drag the formula down.
 
Back
Top