Forum Discussion

Post Patron

6 years ago

Conditions for Columns

Hi All, I have senario like below table . Main Table SNO MG MU MP LG LU Percentage1 Percentage2 1 XX AA BB CC DD ...

Super User

6 years ago

Create calculated column like below:

Column 1 = if(OR(HASONEVALUE(Sheet7[MG]),HASONEVALUE(Sheet7[MU])),"Yes")

Column2 = if(OR(HASONEVALUE(Sheet7[LG]),HASONEVALUE(Sheet7[LU])),"No")

Please give Thumbs up for support and accept this as a solution if it helps you!

Post Patron

6 years ago

If i would like to add one more column (MP), when i add MP Column, syntax is showing wrong. Can u pls let me know.

Thanks