Is there a formula that can return a true false response after looking at a group of variables and determining whether at least one of those variables has a value greater than 2?
Variable names as follows:
PCLC_1
PCLC_2
PCLC_3
PCLC_4
PCLC_5
Values range from 1 - 5 for each variable. Needs to calculate even if there is missing data.
![]()
Bookmarks