Explain why this is invalid

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 Solved
0 12 762
1 ACCEPTED SOLUTION

12 REPLIES 12
Top Labels in this Space