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 is/are the formula(s) ?

=AND()

=EXACT()

Put this formula:

{=AND(EXACT(A2:C2,A2))}

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

Interesting Topics