Validate cells with the same value with a formula in an excel report

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.

macro excel


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 ?



Put this formula:


Then press CTRL + ALT + ENTER to put it into bracket.

Interesting Management