How to get 'TRUE', 'FALSE', and 'Leave BLANK', & also how to average some data

Hi all,

I am doing some analysis tables for a local sports team and I want to make it quicker to update rather than inputting the information onto several sheets. Ideally just input the scores and all the relevant cells update. Some of the values were easy using IF and IFCOUNT. However, when it came to setting up a best of 3 games I couldn't find a way to get an answer from 3 results without analysing the results separately and then getting the info from those new cells.

Example: Badminton Matches (you play best of 3 games each to 21pts)

How do I get it to analyse a win or a loss from 6 cells? (21-19, 19-21, 21,19) (This would be a WIN for the home team)) and....How when no data is in will it leave the cell blank? (IF only allows for TRUE or FALSE, (WIN or LOSS))

A rather stuck

Ben

Do you have a file that you're working from? If so, could you upload it and point out what your desired results are?

yeah sure,

I hope this helps,

Book1.xlsx

Ben

Sorry, just saw your comment.

I left comments on the workbook but if they don't work here's it itemised,

Column F (Rubbers): those results need to show WIN, LOSS or 'nothing at all'

Columns G & H are the first game, representing my team and our opponents scores. G>H will result in a win but only 1 out of 3. So for Column F to say 'WIN' at least 2 out of the three results need to be wins.

I basically want to find a way for it to update when I put the scores in without me manually putting in WIN or LOSS in the F columns as the season progresses. Also while no data is in I want it to say nothing at all rather than the LOSS it would say if I used 'IF' (which only has two outcomes 'TRUE' or 'FALSE'

The only way I can come up with to do it is to create another column for each individual game and literally count that if we get 2 positive results its a WIN - only 1 still means a LOSS.

That works perfectly,

Thanks so much that is exactly how I wanted it to work - so now I see I needed to add a simple count less than 4 results leave it blank.

Thanks for the help.

Ben