lundi 30 avril 2018

IF Formula to return value only if A1=A2, B1=B2

I am trying to return the values of a formula only if, for example, A1=A2 and B1=B2.

The formula I currently have is:

=IF(OR('Tournament Sheet'!G95="",'Tournament Sheet'!I95=""),
    "", IF(AND('Tournament Sheet'!G95='Player Sheet'!G95,
    'Tournament Sheet'!I95='Player Sheet'!I95),5,
    IF(OR('Player Sheet'!G95-'Player Sheet'!I95='Tournament Sheet'!G95-'Tournament Sheet'!I95,
    AND('Player Sheet'!G95>'Player Sheet'!I95,
    'Tournament Sheet'!G95>'Tournament Sheet'!I95),
    AND('Player Sheet'!I95>'Player Sheet'!G95,
    'Tournament Sheet'!I95>'Tournament Sheet'!G95)),2,0)))

I have tried to add if(and(a1=a2,b1=b2) in different locations within the formula and it is just returning different values. The current formula works fine but I need this extra code to go in.

Any ideas? I'm fairly new to excel so your patience is appreciated.

Aucun commentaire:

Enregistrer un commentaire