I need assistance to understand how to combine the "and" & "or" statements together to get a panel to hide or unhide.
I have a panel that needs to unhidden based on four different scenarios:
- DropDown1 must equal: "PSV" for the panel to unhide
- If DropDown1 is equals: "PSE" but field value DropDown2 is equal to "NO" the panel should unhide.
- If DropDown1 is equals: "PSE" but field value DropDown2 is equal to "YES" and DropDown3 is equal to "NO" the panel should unhide.
- If DropDown1 is equals: "PSE" but field value DropDown2 and DropDown3 are equal to "YES" and DropDown4 is equal to "NO" the panel should unhide.
I have been able to get the first two scenarios to work but I am not sure how to incorporate the last two scenarios.
I currently have the following formula on the panel that is hidden.
- and(not(equals(Valve/Disc,"PSV")), not(equals(PSEAPCRequestforAPCcan15gallons, "NO"), or(not(equals(PSEAPCIsAPCcanuse, "NO")))))
Your help is greatly appreciated.
Best answer by MegaJerk
View original