Hi guys,
I`m trying to automate a process/quicken it for some predictions I capture from friends for a football competition.
Using my table attached, can someone help me with writing an IF formula in cell F2 to say:
IF C2 matches B2, return the value 10, if C2 does not match B2, return the value 0
In G2 if the first number of E2 matches the first number of D2, return 5, if the first number of E2 does not match the first number of D2, return 0
In H2 if the second number of E2 matches the second number D2, return 5, if the second number of E2 does not match the second number D2, return 0
I`d really appreciate the help guys.
Bookmarks