OR function
The first formula will turn the cell to 1 (TRUE) if ID5 or ID6 =1. The second example shows a more complex variation that combines a SUM function, where 3 studies need to be True OR ID5:
#Formula 1
=OR(ID5.SG1=1,ID6.SG1=1)
#Formula 2
=OR(ID5.SG1=1,SUM(ID6.SG1,ID7.SG1,ID8.SG1)>=3)
AND function
=AND(ID5.SG1>=ID6.SG1,ID6.SG1<ID5.SG1)
Getting Started
Getting Started, Opening Charts and Basic Trading
Sierra Chart Official FAQ
Help/Frequently Asked Questions List - Sierra Chart
Chartbooks
Data Feed
Sierra Chart Exchange Data Feed
Back Testing
Auto Trade System Back Testing
Spreadsheet Functions
Sierra Chart Support Board