It happens that the cell contains a number or a percentage, for instance, if I am exporting the SLA data. To know in a quick way if it is good or not, I can use the conditional formatting option by putting colors. The other way is to use a formula telling it by a word. This is especially useful when for instance I have to do a pie chart just to show “good” and “bad”.
When I use the formula ?
When I want to show by a word a result than by a percentage or number.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
This formula without between:
This formula with between:
- If in B2 I have 98%, it will show “good”
- If in B2 I have 89%, it will show “bad”
- If in B2 I have 92%, it will show “correct”
- If in B2 I have 95%, it will show “correct” (not “good”)
As you can read in the last example, if I have 95%, it is not showing “good” but “correct”. If I want to include the 95%, I have to add in the formula the = sign, for example: