jeudi 28 juin 2018

How do I create a formula in excel that compares text in cells and returns a percentage

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