Multiple conditions

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
 
C

ck13

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top