back and lay commands

General announcements and other important news

back and lay commands

Postby wbabc » Sun Aug 23, 2026 7:02 am

I have spreadsheet set up to do simultaneous back and lay when the back odd are greater than the lay odds
The back command works - =IF(BL8="","",IF(I8>J8,"back","\\")) filling in all the expected places I have run this down to row 15
The lay commend =IF(BL8="","",IF(I8>J8,"lay","\\")) which I have placed in rows 17 to 24will only fill the stake column – it does not enter placed in that column nor does it enter data into the rest
So the situation is that if the back command is issued the lay command does not operate and fill in details in the status etc columns
Any ideas
wbabc
 
Posts: 4
Joined: Mon Dec 18, 2023 7:08 am

Re: back and lay commands

Postby Gavin » Mon Aug 31, 2026 6:24 pm

Hi wbabc,

I suspect that I8 > J8 is never possible, because it would be matched in the exchange.

Kind regards,

Gavin
User avatar
Gavin
Site Admin
 
Posts: 3937
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Announcements by Cymatic

Who is online

Users browsing this forum: No registered users and 5 guests

cron