Is there a way to find out the values ​of 4 cells are the same or different in MS Excel

Question

I found something confusing in Microsoft Excel. I fill Cell A1, A2, A3, A4 with the same number 1, then I enter the formula = A1 = A2 = A3 = A4 on cell A5, why do I get FALSE results?

Is there a way to find out the values ​​of 4 cells are the same or different?

Answer 1

If all you are using is these numbers you could check for the standard deviation. If it's 0 then all values are equal:

=STDEV.P(A1:A4)

So a check for equality could look like:

=IF(STDEV.P(A1:A4),"Different","Equal)