Looking for some help on excel - I'm sure this is a simple one for you all.
I am looking to write a formula which states if a value is between X% and X%, then the text in the cell will read X.
An example would be if a percentage in cell C4 is between 1%-39%, then cell D4 should read "Unsatisfactory". 40%-49% would be "Of Concern" etc.
The values are:
0% = N/A, 1%-39% = Unsatisfactory, 40%-49% = Of Concern, 50%-64% = Satisfactory, 65%-79% = Good, 80%-89% = Very Good and 90%-100% = Excellent
Aucun commentaire:
Enregistrer un commentaire