We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
26 Mar 10
11:33
Joined:
Date Joined:
08 Aug 08
Hi all
Formula in cell is
=100/(W1013/W1033*100)
what I want is, if the number in this cell is less than 350, I want to nomber to be 0 (zero)
tia
GGR
Formula in cell is
=100/(W1013/W1033*100)
what I want is, if the number in this cell is less than 350, I want to nomber to be 0 (zero)
tia
GGR
sort by:
Show
per page
Replies: 8
|
By:
=IF(100/(W1013/W1033*100)smallerthansign350,0,100/(W1013/W1033*100))
The number after the first comma is what goes in the cell if your condition (being smaller than 350, the sign for which doesn't work on betfair) is met (In this case zero). The number after the second comma is what goes in there if it's over 350 (In this case, the original formula) |
|
By:
Many thanks lori, I will give it a go.
just experimenting on making my own tissue |
|
By:
Got a simpler one for you
tia if cell w970 is less than 301, cell x970 to be 0 |
|
By:
In cell x970
=if(w970islessthansign301,0,"") What do you want x970 to be if w970 is greater than 301? In the above example it will be blank. |
|
By:
In cell x970
=if(w970islessthansign301,0,"") What do you want x970 to be if w970 is greater than 301? In the above example it will be blank. Thanks SM The numbers in both cells are the same so I want the number to stay the same in w970 |
|
By:
Right, this should do that:
In cell x970 =if(w970islessthansign301,0,w970) |
|
By:
Many thanks will give it a go
|
|
By:
Spot on
Thanks again. |