IFS function
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.
Comments
-
Have you seen this article as it might help you....
https://community.anaplan.com/t5/How-To/Decreasing-the-length-of-your-formulas/ta-p/88467
0 -
@rob_marshall Indeed, that's useful for Anaplan as it is now. I still think this would be useful as a feature suggestion though.
0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!