Try
=IF(OR(D3="X",D3="Y"),IF(B3,B3+IF(D3="X",E1,F1),A3 +E1),"")

--
Jacob


"Don" wrote:

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