Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 23:55:17 +0000



[User Discussion] - SPREADSHEET TRADING SYSTEM QUESTION

View Count: 1608

[2013-08-30 00:05:35]
User14682 - Posts: 83
HOW DO I CODE MORE THAN JUST ONE 1 OR 2 RULES? HOW DO I ADD MORE TO THIS? =AND(CROSSFROMBELOW(AA3:AA5,AG3:AG4),AG3>AE3)
[2013-08-30 00:22:46]
Sawtooth - Posts: 4118
The AND function can have more than 2 conditions.

There is also the OR function.

Here are some reference links:
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetFunctions.html#AvailableFunctions
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx

(Forum etiquette: Caps means you are yelling)

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account