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.
|