Evaluating a group of cells
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
|