The formula I listed is not a question of doubt. It works. See image below and attached file![yesno.PNG yesno.PNG](https://community.jmp.com/t5/image/serverpage/image-id/6378iD141C1A2EA195789/image-size/large?v=v2&px=999)
What may be of issue is that your data may have mixed case. "No" is not equal to "no", or "NO". If this is the case, then I suggest
If(
Uppercase( :A ) == "NO", "No",
Uppercase( :B ) == "NO", "No",
Uppercase( :C ) == "NO", "No",
Uppercase( :D ) == "NO", "No",
Uppercase( :E ) == "NO", "No",
Uppercase( :F ) == "NO", "No",
Uppercase( "Yes"
)
Also, please note the ":" in front of each column name. This is important for JMP to understand that it needs to look into a column by the specified name
Jim