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 ?
=IF()
=AND()
This formula without between:
=IF(B2>95%,"good",IF(B2<90%,"bad","correct"))
This formula with between:
=IF(B2>0.95,"good",IF(AND(B2>0,B2<0.9),"bad","correct"))
For instance:
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:
=IF(B2>=95%,"good",IF(B2<=90%,"bad","correct"))
Take note that for some functions like SUMIF, COUNTIF, etc., it will be:
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...