Jul 02 2021 05:16 AM
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
Jul 02 2021 08:20 AM - edited Jul 02 2021 08:21 AM
Jul 02 2021 08:20 AM - edited Jul 02 2021 08:21 AM
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.
Jul 02 2021 08:23 AM - edited Jul 02 2021 08:34 AM
i think you could use an equation like:
=IF(COUNTIF(Z13:Z15,501)>=2),"W","L")
Jul 02 2021 08:34 AM
SolutionJul 02 2021 01:55 PM
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
Jul 02 2021 08:34 AM
Solution