I am trying to compare 6 cells, and get a pass or fail at the end, but in Excel it looks like it will only let me have 5 cells. I'm not sure how to word it.
like for example:
Pseudocode: if (A1 and B1 and C1 = A100 and B100 and C100 then Pass else Fail) =if(A1;B1;C1=A100;B100;C100,Pass,Fail)
That doesn't work, and Excel says I typed a few errors.
Please can someone help me with this?
Updated Ok, to make this a little more clearer, here is an example of what I want to achieve:
A1 = 22.214.171.124 B1 = 01/01/2000 C1 = 00:30 A100 = 126.96.36.199 B100 = 01/01/2000 C100 = 00:30
Therefore the cell I want the answer will be
But if one of those cells don't match up, then it will be a