One of the most powerful "recent" functions I've used in Excel is IFS(), where a single statement can replace multiple levels of IF THEN ELSE statements.
From Microsoft's description:
Generally, the syntax for the IFS function is:
=IFS(Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
My own modeling could be greatly streamlined if Anaplan offered a similar statement that could evaluate multiple sequential tests without having to create multiple nested layers of IF THEN ELSE.
