SOLVED

Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2510292%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510292%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%20i%20have%20been%20trying%20for%20days%20to%20come%20up%20with%20the%20right%20formula%20for%20a%20page%20i%20have%20made%20up.%20I%20play%20darts%20for%20sports%20and%20you%20can%20see%20i%20have%20done%20an%20example.%20As%20you%20can%20see%20player%201%20and%202%20both%20have%203%20rows%20of%20numbers%20which%20we%20call%20legs%20and%20player%203%20and%204%20only%20have%202%20that%20is%20because%20you%20can%20win%202%20legs%20straight%20or%20you%20have%20to%20play%20a%203rd%20leg%20as%20both%20players%20have%20won%201%20leg%20each%20but%20what%20I%20am%20after%20is%20a%20formula%20where%20under%20W%2FL%20in%20column%20AB%20it%20will%20automatically%20work%20that%20if%20there%20is%20only%202%20legs%20with%20501%20it%20is%20a%20W%20and%20if%20there%20is%202%20legs%20499%20or%20under%20it%20is%20a%20L%2C%20and%20where%20there%20are%20the%203%20legs%20the%20formula%20needs%20to%20work%20out%20that%20if%20there%20is%202%20legs%20with%20501%20and%20a%20499%20or%20under%20that%20it%20is%20still%20a%20W%20and%20like%20player%202%20if%20it%20is%20only%201%20leg%20with%20501%20and%20the%20other%202%20are%20499%20and%20under%20it%20is%20a%20L.%20It%20doesn't%20matter%20if%20player%203%20and%204%20have%20the%203%20legs%20and%20so%20on%20as%20they%20change%20all%20the%20time.%20I%20hope%20that%20someone%20can%20put%20me%20on%20to%20the%20right%20formula.%26nbsp%3B%20Thank%20you%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22example.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293119i931FA2D0B28731E8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22example.jpg%22%20alt%3D%22example.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2510292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2510987%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510987%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI'd%20like%20to%20ask%20you%20to%20help%20us%20help%20you.%20You%20can%20make%20our%20lives%20easier%20(and%20get%20a%20better%20chance%20of%20receiving%20help)%20by%20two%20things%3A%3CBR%20%2F%3E1.%20Please%20use%20interpunction%20in%20your%20text%2C%20your%20current%20message%20is%20very%20hard%20to%20understand.%3CBR%20%2F%3E2.%20Please%20upload%20an%20Excel%20file%20rather%20than%20a%20screen-shot.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2510989%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510989%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20think%20you%20could%20use%20an%20equation%20like%3A%3CBR%20%2F%3E%3DIF(COUNTIF(Z13%3AZ15%2C501)%26gt%3B%3D2)%2C%22W%22%2C%22L%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone i have been trying for days to come up with the right formula for a page i have made up. I play darts for sports and you can see i have done an example. As you can see player 1 and 2 both have 3 rows of numbers which we call legs and player 3 and 4 only have 2 that is because you can win 2 legs straight or you have to play a 3rd leg as both players have won 1 leg each but what I am after is a formula where under W/L in column AB it will automatically work that if there is only 2 legs with 501 it is a W and if there is 2 legs 499 or under it is a L, and where there are the 3 legs the formula needs to work out that if there is 2 legs with 501 and a 499 or under that it is still a W and like player 2 if it is only 1 leg with 501 and the other 2 are 499 and under it is a L. It doesn't matter if player 3 and 4 have the 3 legs and so on as they change all the time. I hope that someone can put me on to the right formula.  Thank you 

example.jpg

5 Replies

Hi,
I'd like to ask you to help us help you. You can make our lives easier (and get a better chance of receiving help) by two things:
1. Please use more interpunction (shorter sentences) in your text, your current message is very hard to understand.
2. Please upload an Excel file rather than a screen-shot.

i think you could use an equation like:
=IF(COUNTIF(Z13:Z15,501)>=2),"W","L")

best response confirmed by allyreckerman (Microsoft)
Solution
that said, if you wanted to make your sheet easily adaptable to a game of 301 or 701 etc... It seems clear that cells in column X would only be filled in for the winner so you could use:
=IF(COUNT(X13:X15)>=2),"W","L")

@Jan Karel Pieterse 

Hi thank you for getting back to me and I apologize greatly, I was trying help people understand how darts worked in scoring to know what I was after and I tried once before on different section and no one understood me, and yes I now know how to put examples up a lot easier. Sorry it made things hard for some to understand.

Tammy

Thank you that equation is what I need.