Forum Discussion

devika's avatar
devika
Icon for Helper II rankHelper II
5 years ago
Solved

If and multiple conditions

I'm creating a column with 'And' ,'Multiple Conditions'   Co = IF(and[RRR]=1, ([Highest]="Rer" or [Highest]="Con" or [Highest]="EC") then 1 else 0)   I worked out for single conditon but trying ...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    Hi.  Try this...

     

    IF(
	AND(
		[RRR] = 1,
		[Highest] IN {"Rer", "Con", "EC"}
	),
	1,
	0
)

     

     

     

devika's avatar
devika
Icon for Helper II rankHelper II
5 years ago

I managed to solve by Switch(true(), [rrr]=1 && [Highest] ="Rer",1,[rrr]=1 && [Highest] ="Con",1,0)

 

I will yours solution too and post it here. thanks for you reply