Forum Discussion

harib's avatar
harib
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    ...
Need Help
Tips and Tricks
Tahreem24's avatar
Tahreem24
Super User
6 years ago

Or try this to get percentage value:

 

Column2 = if(Sheet7[Group] in {"MG","MU","MP"},0.01,0.02)
 
Don't for get to hit Thumbs up for support and accept this as a solution if it helps you!
harib's avatar
harib
Post Patron
6 years ago

Tahreem24 

 

I have used Related function to call the percentage values from the main table. But not getting percentage for LG,LU values. I dont want to give manuval values.