Is there an ELSE IF or Switch statement in Anaplan

Options
blairvham18
blairvham18 Member, ALL USERS, Partner Posts: 2 New Contributor
in Anaplan Community

Hello,

 

I am trying to create an IF statement with 3 possible answers. I was able to do it in excel using this formula:

 

IF(C2="SUPPORT",0 IF(C2="BILLABLE",1,IF(C2="FREE",-1)))

 

But I was wondering if there was a way to do it in Anaplan so I can use the conditional formating with text rather than numbers.

 

Thanks

Tagged:

Comments

  • blairvham18
    blairvham18 Member, ALL USERS, Partner Posts: 2 New Contributor
    That worked! Thank you!
    Quick question, why would the LOOKUP be more efficient than the IF ELSE statement?

Categories