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 = 1.0.0.0
B1 = 01/01/2000
C1 = 00:30
A100 = 1.0.0.0
B100 = 01/01/2000
C100 = 00:30
```

Therefore the cell I want the answer will be `Pass`

.

But if one of those cells don't match up, then it will be a `Fail`

.

`=IF(AND(A1=A100,B1=B100,C1=C100),"pass","fail")`

– nixda Aug 20 '13 at 10:06`all the fields are blank`

then, of course the formula will return`pass`

. If that is not the result you expect, then you need to explain the input, the logic, and the expected output. – teylyn Aug 20 '13 at 10:44