Compare 4 cells

J

John

I want to be able to have a message in a cell that alerts users to the value
in each of the four cells being the same:

EG If A1,B1,C1,D1 are all the same value then put a message in B1.

I tried to use the AND function but it came back as false. Any ideas please
on how i might do this.

Thanks
John
 
J

John

please ignore this as i've put the message in the wrong Forum. Apologies for
this.
John
 
Top