Return true if multiple cells are the same

G

Guest

I have cells A1 to E1 with same values. In cell F1, I want to return "true"
if cell A1=B1=C1=D1=E1. The result I get was #N/A when I enter the formula
"=A1=B1=C1=D1=E1". Anyone knows the answer?
 

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

Formula for If "" AND "" are true... 3
Different cells that need to sum in one 4
Excel 2007 storing the high and low 3
Nested IF Help 3
Copy/Paste formulas in merged cells 2
Looking at multiple cells 3
Nested IF statement 3
Excel Add ^ to a row of cells containing letters 3

Top