OR(
AND([current level]=1,[L1 Assessment Linked].[level 1 score]>94%, [L1 I-CAR Classes].[completed]>84%),
AND([current level]=2,[L2 Assessment Linked].[level 2 score]>94%, [L2 I-CAR Classes].[completed]>84%),
AND([current level]=3,[L3 Assessment Linked].[level 3 score]>94%, [L3 I-CAR Classes].[completed]>84%)
)
I am trying to say that when the Level is X, check that the following items are also true. I am using this for a format rule, so I need a boolean result. Are nested OR/AND functions not supported? I continue to be flummoxed by the spreadsheet-style logic used at times.
Solved! Go to Solution.
User | Count |
---|---|
16 | |
8 | |
7 | |
3 | |
2 |