This formula will check if all the 3 cells have the same value, quite useful to validate it but much more useful, combine with the IF function for instance so I can ask it to change one of the values or something else.
When I use the formula ?
To check that all cells have the same result.
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 ",".
For the formula to work properly, I need to do an additional action, by pressing “control + shift + enter” in order to put the formula between brackets. If not, it will show an error
How are the formulas ?
=AND()
=EXACT()
Put this formula:
{=AND(EXACT(A2:C2,A2))}
Then press CTRL + ALT + ENTER to put it into bracket.
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...