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) |