multiple actions in one formula

[krisryan]

I have been wrestling with this for hours and I cannot make it work. Maybe it can't?

In one cell (L6) i have this formula:

=IF(F6="","OPEN","CLOSED") which is telling excel that if there is no invoice date in F6 (true) then it will need to say open and if there is an invoice in F6 (false) it will need to say closed and it works perfectly however, I need to add to that same formula:

=IF(C6="VOID","VOID") which is telling it if the word void is in C6 (true) instead of an invoice date then it (L6) should say void. I am not sure what I could put as a "false" for that (maybe ""?) and not sure if I can do it without a false. I have never had a need for a formula like this but I attempted to google to find it to no avail. I tried nested IF's and AND and can't figure it out.

[cbatrody]

Hi,

Modify the formula in L6 as following:

Please Login or Register  to view this content.

[oeldere]

Try this one, and see if it get the expected result

=IF(C6="VOID","VOID",IF(F6="","OPEN","CLOSED"))

[krisryan]

Hi,

Modify the formula in L6 as following:

Please Login or Register  to view this content.

Thank you so much! I guess I need to research and gain understanding on the double parentheses at the end as it looks like that was one of my issues.

[krisryan]

Try this one, and see if it get the expected result

=IF(C6="VOID","VOID",IF(F6="","OPEN","CLOSED"))

Thank you. I appreciate you taking the time to answer my question.

[cbatrody]

You are welcome, glad we could help

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.