Nested IF and AND to create a custom column

[SS_1122]

Hey All,

Thank you in advance to help me solve this problem.

I am trying to create a custom column called "File check" with the help of the below data:

So, the calculation I wrote for File Check is :

File Check = if (Table [key] = 1 && Table[value] = 1 && Table[key] =2 && Table[value] = 1, "File check Successful", if ( Table [key] = 1 && Table[value] <> 1 && Table[key] =2 && Table[value] = 1 , "File check Not Successful", if(Table [key] = 1 && Table[value] = 1 && Table[key] =2 && Table[value] <> 1  , "File check Not Successful", if (Table [key] = 1 && Table[value] <> 1 && Table[key] =2 && Table[value] <>1 , "File check Not Successful"))))

But this shows nothing in the column and I relaized that I cannot have multiple "&&" , but I am not sure how to write this with switch statement.

Thanks

[amitchandak · Accepted solution]

@SS_1122 , It should be like

File Check = Switch (True() ,
(Table [key] = 1 && Table[value] = 1 )|| (Table[key] =2 && Table[value] = 1), "File check Successful",
(Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] = 1 ), "File check Not Successful",
(Table [key] = 1 && Table[value] = 1) || (Table[key] =2 && Table[value] <> 1) , "File check Not Successful",
(Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] <>1) , "File check Not Successful")