How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- Office Version
- 2010
- Platform
- Windows
I’m comparing the results of a football team in a 24 team league against the Top 12 in a table or the Bottom 12 in a table…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
So, in my formula below =IF(Played!$X$9="T" establishes which half at the table to look at but then there’s a lot of duplication in the True and False part of my formula… How can I tidy my formula up please?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>So, in my formula below =IF(Played!$X$9="T" establishes which half at the table to look at but then there’s a lot of duplication in the True and False part of my formula… How can I tidy my formula up please?
| Excel Workbook | |||
|---|---|---|---|
| AP | |||
| 29 | |||
| 30 | Millwall | ||
Mini Leagues | |||
