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

Copper Contributor

Hello all,
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?

 

thanks

 

 

0 Replies