Kill nested IFs
What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)
Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.
Yes, but only if you have Office 365. Will it be available for Office Desktop Pro?
Oh, you're already done. Great, thanks! Now how do I convince IT to roll out Office 2016? We just got 2013. ;-)