Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
starfish and coffee
27 Apr 10 10:38
Joined:
Date Joined: 03 Sep 08
| Topic/replies: 8,055 | Blogger: starfish and coffee's blog
Column A = % chance
Column B = 100/a

In column C i want the following:-

If (a1 is more than 19.99 return b1*.9), If (a1 is between 15 and 19.99 return b1*1.1), If (a1 is between 10 and 14.99 return b1*1.5)

What would be the excel formulas please? the examples I've been looking at don't seem to apply

Cheers!
Pause Switch to Standard View Excel formula help please
Show More
Loading...
Report Don No1 April 27, 2010 10:59 AM BST
=IF(A1>19.99,B1*0.9,IF(AND(A1>14.99,A1<20),B1*1.1,IF(AND(A1>...
Report starfish and coffee April 27, 2010 11:03 AM BST
thanks Don! .. i took out the 2 commas towards the end and it works fine
Report Don No1 April 27, 2010 12:03 PM BST
No problem
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com