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