IF Formula with multiple conditions.

[dans1988]

Hi all,

I am after a formula that compares figures in cells to each other and if they match will give me a TRUE response or FALSE if they don't.

For example; Cell A54 must match with A54 on worksheet 2, but as must 4 other cells, say B54, C54, D54, E54 match to the corresponding cells on worksheet 2 to fulfill the query. Also what is the maximum conditions that can be tested as I may need more than 4 tests.

If anyone can be of assistance it would be very appreciated!

 

[JackDanIce]

Formula might be:

=AND(A54 = Sheet2!A54, B54 = Sheet2!B54, C54 = Sheet2!C54, D54 = Sheet2!D54, E54 = Sheet2!E54)

No idea about number of arguments AND test can hold. I'm sure you can do an internet search to find this out.

 

[dans1988]

Thanks Jack, I will give this a try.

 

[JackDanIce]

You're welcome