General Betting
There is currently 1 person viewing this thread.
27 Apr 10
10:38
Joined:
Date Joined:
03 Sep 08
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!
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!
sort by:
Show
per page
Replies: 3
|
By:
=IF(A1>19.99,B1*0.9,IF(AND(A1>14.99,A1<20),B1*1.1,IF(AND(A1>9.99,A1<15),B1*1.5,),))
|
|
By:
thanks Don! .. i took out the 2 commas towards the end and it works fine
|
|
By:
No problem
|