If all = Competent then competent, if not, then inconsistent
I need help with a formula. People choose their skill based on a certain topic:
I need a formula that looks at all the children and determines that:
- If 1 inconsistent, no matter what else, show as inconsistent
- If all competent or expert, show as competent
I am guessing it can be easily achieved by saying if there is 1 inconsistent then inconsistent, otherwise, show competent. But i am not sure how this will look in a formula?
Any help would be much appreciated.
Help Article Resources
Check out the Formula Handbook template!