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]

What conditions are you searching for? Please explain further.

 

[ccoleman]

Hard to say without know what you're trying to do, you can use And() to have multiple ifs but you can get that same effect by nesting.

 

[mmckillen]

I am not really searching for a condition; I just want to have 2 full IF's in one cell:

=IF(D3="",(C12+H13),(C3+G13)+(D3-C3))
=IF(D4="",(C12+H13),(C3+G13)+(D4-C4))

Maybe there is a condition or an additional formula out there, I thought at first you might just be able to close each individual if and separate them by a comma... obviously didn't work

If you want contect for the formulas I can go into more detail.

 

[mmckillen]

@ccolman -

Isn't it true that And() returns True or False?

If not, how would I link 2 IF's that need to return a specific date?

 

[Norie]

You can have a whole load of IF statements in one cell.

If you are going to try nesting them though you might run into limitations, but if you do then it's probably time to look at something other than IF.

 

[Special-K99]

What happens if BOTH conditions are false?
Should Excel display (C3+G13)+(D3-C3) or (C3+G13)+(D4-C4) ?

 

[mmckillen]

@ Everyone -

Maybe a little more context would help. I am building a project management spread sheet and need to change due dates based on late or early submissions. Some tasks may be delayed because of different tasks being turned in late. The task that needs the date change could be affected by multiple previous tasks.

So task C's due date may be affected by task A and B. In that case the formula in cell C needs to have two IF statements corresponding to task A and B.

Any thoughts?

 

[mmckillen]

@ Special K99 -

Those are calculating dates, not returning True or False. The conditionals are D3="" and D4="".

 

[Special-K99]

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)