I have a excel spreadsheet that every cell will have either three values, Pass, Fail or na(not available). This is an example of what the spreadsheet will look like
So I will like to have a formula that will compare all the cells and returned 100% "completion" when all the cells have "Pass" on them.
Aucun commentaire:
Enregistrer un commentaire