CodePudding user response:

CodePudding user response:

=the IF (=A2 B2, C2, the IF (A2=C2, B2, IF (B2=C2, A2, C2)))

CodePudding user response:

What if the same rules

CodePudding user response:

IF (A1=C1, B1, the IF (=C1, B1 A1, C1))
Column A and B are equal, all output column C, so don't judge AB column

CodePudding user response:

This formula is very concise, upstairs is good

CodePudding user response:

At present I don't know who show A=B=C cases, the answer can be # 4 floor