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.

1 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!