Efficient way of writing multiple conditions?

Sharmi_thangam_malat · December 9, 2018, 4:41am

Hello ,

I have the below scenario :

If Experience <=“3” , Salary =5LPA
If EXP > 3 EXP <=5 Salary = 7 LPA
IF Exp >5 ; Exp <= 9 , Salary =10 LPA

i have 3 if condition’s for this.How to write this efficiently ?

Thanks,
S

palindrome · December 9, 2018, 5:21am

If by efficient you mean to write If statement in just 1 line. Then you can use below method:

Use assign activity to write the if statement:

If(EXP<=3 and Salary = "5LPA","group-1",If(EXP>3 and EXP<=5 and Salary="7LPA", "group 2",if(EXP>5 and EXP<=9 and Salary="10LPA","group 3","none")))