View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default 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