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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!