Hello Guys,
I have the table below and I want to check if the values from all 3 columns are equal-If true to display “Yes”, if not-”No”.
Here is the table:
I tried the IF function but I think that I ‘m not doing it right.
Thanks a lot
Hey Corina!
I think we should be able to achieve that with if, something like if( (col1 = col2 AND col1 = col3), “Yes”, “No”)
But your first and third columns have exactly the same names, don’t they? That may potentially cause some confusion, maybe selecting wrong option when creating calculation, so it is better to doublecheck on it and maybe label one of them differently so that we can differentiate them