IFS function

scwooten

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.

rob_marshall

@scwooten 

 

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

 

 

scwooten

@rob_marshall Indeed, that's useful for Anaplan as it is now. I still think this would be useful as a feature suggestion though.