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
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