Forum Discussion
IF AND
Hi Anonymous ,
Try using SWITCH () function
SWITCH(
TRUE(),Table[Column1] = "A", "Returns A",
Table[Column1] = "B", "Returns B",
Table[Column1] = "C", "Returns C",
"others"
)
You can have a look at the videos.
https://www.youtube.com/watch?v=-ykkaAtlCMc&vl=en
https://www.youtube.com/watch?v=UsAJPIANAb8
For Nested IFs
https://www.youtube.com/watch?v=rXDomxfoY1o
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Hi Anonymous ,
Try using SWITCH () function
SWITCH(
TRUE(),
Table[Column1] = "A", "Returns A",
Table[Column1] = "B", "Returns B",
Table[Column1] = "C", "Returns C",
"others"
)
You can have a look at the videos.
https://www.youtube.com/watch?v=-ykkaAtlCMc&vl=en
https://www.youtube.com/watch?v=UsAJPIANAb8
For Nested IFs
https://www.youtube.com/watch?v=rXDomxfoY1o
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
thankyou Anonymous