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