Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-898305%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898305%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20scoring%20method%20for%20a%20golf%20tournament.%26nbsp%3B%20I%20want%20to%20compare%20the%20recorded%20score%20to%20par%20on%20the%20hole.%26nbsp%3B%20If%20the%20score%20is%20equal%20to%20par%2C%20I%20want%20to%20assign%20a%20value%20in%20another%20cell.%26nbsp%3B%20If%20the%20score%20is%20less%20than%20part%2C%20I%20want%20to%20assign%20a%20different%20value%20and%20if%20the%20score%20is%20more%20than%20par%2C%20I%20want%20to%20assign%20a%20different%20value.%26nbsp%3B%20For%20example%2C%20a%20score%20one%20less%20than%20par%20receives%20a%20value%20of%204%3B%20a%20score%20one%20more%20than%20par%20receives%20a%20value%20of%201%20and%20a%20score%20equal%20to%20par%20receives%20a%20value%20of%202.%26nbsp%3B%20A%20score%20of%20two%20(2)%20less%20than%20par%20receives%20a%20value%20of%208.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20set%20this%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-898305%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901401%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421710%22%20target%3D%22_blank%22%3E%40Smoothfire%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20much%20about%20golf%20but%20I%20tried%20to%20prepare%20a%20solution%20for%20you.%20Attached%20file%20shows%20how%20you%20could%20do%20that.%20You%20will%20need%20to%20adjust%20the%20formula%20to%20what%20you%20need%20but%20it%20should%20give%20a%20general%20understanding%20of%20how%20you%20could%20do%20it.%20I%20hope%20it%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fkteamch-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fpascal_kiefer_kteam_ch%2FEQKqeKOO0TBPviMRs3UL500BBYl82hHvmnL9UeZCEK5goA%3Fe%3DdmVoGi%26amp%3BDownload%3D1%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFile%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Smoothfire
Occasional Visitor

I am creating a scoring method for a golf tournament.  I want to compare the recorded score to par on the hole.  If the score is equal to par, I want to assign a value in another cell.  If the score is less than part, I want to assign a different value and if the score is more than par, I want to assign a different value.  For example, a score one less than par receives a value of 4; a score one more than par receives a value of 1 and a score equal to par receives a value of 2.  A score of two (2) less than par receives a value of 8.

 

How do I set this up?

1 Reply

@Smoothfire 

 

I don't know much about golf but I tried to prepare a solution for you. Attached file shows how you could do that. You will need to adjust the formula to what you need but it should give a general understanding of how you could do it. I hope it helps.

 

File

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies