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
Chit Chat
There is currently 1 person viewing this thread.
01 Aug 15
10:54
Joined:
Date Joined:
23 May 09
I need some simple code that will put the trigger -1 into cell Q2 if cell V5 is not blank.
I've searched the gruss forum but no joy and excel/vba code hurts my brain.
Any help please
I've searched the gruss forum but no joy and excel/vba code hurts my brain.
Any help please
sort by:
Show
per page
Replies: 11
|
By:
In cell Q2 put
=IF(V5"",-1,"") |
|
By:
=IF(V5"",-1,"")
|
|
By:
It missed out the smaller than/greater than part of the formula that should be inserted between V5 and ""
|
|
By:
If(v5="","",-1)
Other way round. |
|
By:
=IF(V5 Smaller than/greater than"",-1,"")
|
|
By:
Oops, I misread the OP
|
|
By:
=IF(V5 Smaller than/greater than"","",-1)
|
|
By:
Thanks for the reply mate but if you use a formula it disappears when gruss refreshes, that's why i need code.
cheers anyway |
|
By:
That went well!!
 I'm sure somebody on here will sort it. |
|
By:
If you ever need future advice, speak to Gary or Mark.
Their support is fantastic, and they always come back pronto. |
|
By:
I don't know about Gruss, but if you open the vba editor and select ThisWorksheet the you can insert code that updates your sheet every time something happens. On the left drop down select Workbook, then either SheetChange or SheetCalculate. You can then insert a simple if statement with runs every time something on the sheet changes or recalculates.
|