So I have a cell with the following information, for example "Score 8/10" and I need a formula that translates to "if the value is between 0 and 4, return "Bad", if the value is between 5 and 7, return "Medium", if the value is between 8 and 10, return "Good".
I tried a If with a mid to extract the "8" from the "Score 8/10", but couldn't manage to get the rest of the result.
Aucun commentaire:
Enregistrer un commentaire