I have a chart to classify people between 1 to 5. I've used radio buttons.
I need a formula for:
1) if they are under a specific number (between 1 and 5) in any criteria, they're not classified
2) if they are above a specific number (between 1 and 5) in all criteria, they are classified.
Can someone help my making this formula?
You need a script, not a formula. Basically you need to loop over all the fields, checking the value of each one and maintaing a variable that checks if any of them is not checked or what the total is.