Multiple If Statements

[mmckillen]

Can you have multiple IF statements in one cell. I know nested IF's are out there, but they will not work for what I need.

I just need to have two (or more) complete IF statements.

Is this possible??

 

[Special-K99]

Doesnt matter whether they are dates or not, the result of the first condition if false is
(C3+G13)+(D3-C3) and second condition if false is (C3+G13)+(D4-C4)

 

[mmckillen]

@ Special K99 -

Ok, but I do not want to return True or False. I want to return a date (mm/dd/yyyy) depending on if a specific cell is empty or populated. I didn't think I could use IF(AND()) for two reasons:

1) I don't want to return T or F
2) I want to return two different values depending on which conditional is met.

 

[mmckillen]

Ohh... so if I have 5 conditions, they can trigger 5 different out puts?

 

[mmckillen]

You've answered your own question.
You are checking for one condition AND other conditions

IF(AND(condition1,condtion2,condition3,...etc,TRUE,FALSE)

(At this stage I'll leave it the others to resolve as I know this is going to get more complex)

Ok I just tried this and here is why I don't think this would work... but I could for sure be wrong.

=IF(AND(D3="",D4=""),TRUE,FALSE)

My problem is that if D3 is false/true I need to return a date in cell A1 and if D4 is false/true I need to return another date and cell A2

So if I use this formula it does go through both conditionals I am checking against, but it can not return two different dates in two different cells.

Does that make sense? Am I thinking correctly?

 

[ccoleman]

I think what you want actually is a nested if, since you can only have one value in the cell either (C12+H13),(C3+G13)+(D3-C3)) if D3 = "" or (C12+H13),(C3+G13)+(D4-C4) if D4 = "" but which one takes precendence? If D3 and D4 are both blank which one do you want it to be?

If(D3 = "", (C12+H13),(C3+G13)+(D3-C3), if(d4 = "", (C12+H13),(C3+G13)+(D4-C4), ""))

This will check to see if D3 is blank then set it to (C12+H13),(C3+G13)+(D3-C3) if it is, if D3 is not blank it will check if d4 is blank and if it is, set it to (C12+H13),(C3+G13)+(D4-C4).

(also a note that in your example if D3 is blank you're subtracting C3 from it which we already know D3 is blank so I'm thinking it's a different cell you want to subtract).