Compare 4 cells

  • Thread starter Thread starter John
  • Start date Start date
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
 
please ignore this as i've put the message in the wrong Forum. Apologies for
this.
John
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reffering another cell value which contains RAND() 0
Evaluating a group of cells 3
Excel Add ^ to a row of cells containing letters 3
Excel functions 0
somewhat complicated conditional formula 2
cells with one to multiple lines 1
Line with length depending on the value of the cell 1
Cells with varying number of lines 1

Back
Top