danielpeam
New Member
- Joined
- Feb 25, 2018
- Messages
- 8
Hey guys,
I have two sets of data - one has an IF formula which leaves the words 'win' or 'lose' based on the results.
Formula is =IF(A15<=C15,"lose","win")
And another which highlights a cell based on conditional formatting formula is =E2>AVERAGE(E$2:E$11)*1.1
What I'd like to have is a formula which combines the two - I figure there are two options, one I'm sure is impossible.
If one cell is highlighted and another cell is highlighted return the result of x.
Alternatively - if cell E2 is in the top 10% of the range of cells, and cell A15 has the value 'win', return the value x.
I have two sets of data - one has an IF formula which leaves the words 'win' or 'lose' based on the results.
Formula is =IF(A15<=C15,"lose","win")
And another which highlights a cell based on conditional formatting formula is =E2>AVERAGE(E$2:E$11)*1.1
What I'd like to have is a formula which combines the two - I figure there are two options, one I'm sure is impossible.
If one cell is highlighted and another cell is highlighted return the result of x.
Alternatively - if cell E2 is in the top 10% of the range of cells, and cell A15 has the value 'win', return the value x.
