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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies