Excel Points Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2993016%22%20slang%3D%22en-US%22%3EExcel%20Points%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993016%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20see%20if%20there's%20a%20formula%20which%20would%20work%20out%20a%20points%20score%20based%20off%20a%20score%20prediction%20matching%20the%20actual%20result%3A%205%20points%20if%20it%20matches%20exactly%2C%203%20if%20it%20matches%20the%20result%20or%201%20point%20if%20just%20one%20side%20matches%20(i.e.%20if%20the%20prediction%20was%203-0%20and%20the%20score%20was%203-0%20%3D%205%20points%2C%20if%20the%20score%20was%202-1%20%3D%203%20points%2C%20if%20the%20score%20was%200-0%20%3D%201%20point).%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2993016%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi!

 

I want to see if there's a formula which would work out a points score based off a score prediction matching the actual result: 5 points if it matches exactly, 3 if it matches the result or 1 point if just one side matches (i.e. if the prediction was 3-0 and the score was 3-0 = 5 points, if the score was 2-1 = 3 points, if the score was 0-0 = 1 point). Any ideas?

0 Replies