| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to verify that 3 cells are equal
Hello,
This should be a relatively easy question but I can't figure it out. How do I verify that three cells are equal? I can verify that two cells are equal but I'm having issues checking against a third cell. Example: A1=2 A2=2 A3=2 If I input =A1=A2, I get "True" but when I input =A1=A2=A3, I get "False" even though all three cells are equal. Any thoughts? Thanks in advance for your help. -Scott |
|
#2
|
|||
|
|||
|
One way:
=AND(A1=A2,A1=A3) In article , "Scott" wrote: Hello, This should be a relatively easy question but I can't figure it out. How do I verify that three cells are equal? I can verify that two cells are equal but I'm having issues checking against a third cell. Example: A1=2 A2=2 A3=2 If I input =A1=A2, I get "True" but when I input =A1=A2=A3, I get "False" even though all three cells are equal. Any thoughts? Thanks in advance for your help. -Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to verify that 3 cells are equal | Excel Worksheet Functions | |||
| Paste link versus allowing two cells equal each other? | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
Linear Mode
