18th April 2007, 09:25 AM
|
|
Member
|
|
Join Date: Apr 2005
Posts: 39
|
|
Quote:
|
Originally Posted by dingoboy
first bet is in row 1, when that bet is over i put the win div into its spot then hit "tab", how can it then "add" the next row including calculations. If i leave it "open" it looks messy and the calculations are all on the incline waiting for a figure in win div.
D
|
I don't know of any way to "switch off" a line. If I understand your requirement correctly you would be happy to "hide" only the remaining calculation fields on the page. I am assuming you will still want your future "bet" entries displayed.
This may be a bit cumbersome but IF conditions can be embedded. You could surround each calc field with another IF condition referring to the win cell on the previous line as follows:
assume H11 holds win details (empty if unused "" or numeric if used 0,etc).
IF(H11="","",IF(H12=0,10+G12+E12,10))
other calcs on line 12 would be: IF(H11="","",( other calc)).
As I said, it is cumbersome but will work if unused win cell is empty. And once you have completed one line you copy the rest. The only wrong 'un of course would be the first line which cannot refer to the previous line.
Hope it helps.
|