问题描述:

sheet 1 sheet 2 sheet 3 sheet 4

a a a a

b b b b

c c c c

a a b a

b b a b

c c a c

a b c b

My question is if all the three sheets contains the same letter then the sheet 4 should contain the same letter.

if sheet 1 and sheet 2 contains a and sheet 3 contains b then the result should be a in sheet 4.

if all the sheets has different letters then the result in sheet 4 should be b.

网友答案:

The Microsoft Excel EXACT function compares two strings and returns TRUE if both values are the same. Otherwise, it will return FALSE.

EXCEL EXACT SYNTAX

EXACT( text1, text2 )

=EXACT(A1, A2)
网友答案:

You can use a if-then-else statement in Excel, it looks like =IF(A=B,True,False); And you can nest one in another.

In sheet 4 (for the example cell A1) =IF(Sheet1!A1="a",IF(Sheet2!A1="a",IF(Sheet3!A1="a","a", "b"),"b"),"b")

This check is sheet1 is A, yes? check sheet 2 etc, else give B.

More about IF in excel: http://www.techonthenet.com/excel/formulas/if.php

相关阅读:
Top