General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I've also posted this on racing, not sure which would get most replies
hi in excel I have
column D that has runners,
column J that has betfair prices,
column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners
column W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
hi in excel I have
column D that has runners,
column J that has betfair prices,
column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners
column W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
Show More
in X1 PUT 15
in Y1 PUT 26.9
in W2 PUT:
=IF(AND(J2 < $X$1, AG2 > $Y$1), "LAY ME", "")
Use conditional formatting on column W to format all cells which contain "LAY ME" to whatever colour you chose
in Y1 PUT 26.9
in W2 PUT:
=IF(AND(J2 < $X$1, AG2 > $Y$1), "LAY ME", "")
Use conditional formatting on column W to format all cells which contain "LAY ME" to whatever colour you chose
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539