Kill nested IFs
What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)
1
vote

Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.
Cheers,
Dan [MS]
2 comments
-
Anonymous commented
Yes, but only if you have Office 365. Will it be available for Office Desktop Pro?
-
Mal commented
Oh, you're already done. Great, thanks! Now how do I convince IT to roll out Office 2016? We just got 2013. ;-)