Generating a text (Pass/Fail) at the bottom of a table based on a majority count means that if the number of conditions are met, it will generate your desired text (Pass/Fail).
To start, navigate your cursor to the left tab and choose 'Prefilled table' under Table. Set your number of columns and rows as you wish. Set your conditions such that there is a number of percent counts results to either "Pass/Fail".
Use the formula IF() to your display cell:
=IF(COUNTIF(Range, Criteria)>Number), "Pass")
For example:
Given that there are 5 employees who took the safety training. The passing score is 80% and 4 of them are above 80%. You require at least 3 of them to have 80% inorder to consider it an overall pass.
Employee 1 | 80% | Pass |
Employee 2 | 75% | Fail |
Employee 3 | 85% | Pass |
Employee 4 | 90% | Pass |
Employee 5 | 95% | Pass |
Overall Pass/Fail? | - | Overall Pass |
To populate the text "Pass" in the display cell, use the formula:
=IF(COUNTIF(C1:C5, "Pass")>=3, "Overall Pass")
NOTE: The display cell has a default display of "false" as there are no selections yet.