This thread was posted in 2013 with a reply that the only solution was to use vba - I think I've found an alternative. The situation is:

I have a complex logic condition that I want to stop once a condition is met, i.e. If condition A is met then do something and stop, else if condition B is met then do something and stop, etc. My solution involves concatenating IF statements and starting each subsequent IF statement with a check on the previous statement such as:

=IF(MAX(First:Last!D12)=0,"No votes cast","")&

IF(MAX(First:Last!D12)=0,"", 'MAX(First:Last!D12)=0 is the first condition
IF(MAX(First:Last!D12)-MIN(First:Last!D12)=0,"Unamious",""))&

IF(MAX(First:Last!D12)-MIN(First:Last!D12)=0,"", 'MAX(First:Last!d12)-MIN(First:Last!D12)=0 is the second condition
IF(MAX(First:Last!D12)-MIN(First:Last!D12)<>0,"list votes",""))

Don't let "First:Last!D12" throw you. It's a way to examine the same cell across multiple tabs, in this case every tab that's between the tab named "First" and the tab name "Last".

I've done some preliminary testing on this and it appears to work but I make no guarantees. Good luck!!