Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching cells and adding a value to the match.
Thanks people, works fine, Cheers
"Teethless mama" wrote: =IF(D3&D4=C3&C4,4,1) "Sibbs" wrote: High guys, bit new to this Excel malarky so any help would be fantastic. I am tring to set a score prediction leauge for our office. What I would like to do is this IF D3 & D4 (Home and away team prediction) MATCH C3 & C4 (Home and Away Team Actual Score) THEN ADD 4 POINTS TO I3. IF D3 OR D4 ARE GREATER THAN C3 OR C4 THEN ADD 1 POINT TO I3. So if the correct score is predicted then 4 points are awarded but if the HOME or AWAY win/draw is predicted but not corrct score then 1 point is awarded. About as clear as mud but any help would be really appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
matching two columns and adding info | Excel Discussion (Misc queries) | |||
Search & match more than one worksheet and matching cells. | Excel Worksheet Functions | |||
Adding data to matching records... | Excel Worksheet Functions | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions |