Support Board
Date/Time: Tue, 11 Mar 2025 11:21:36 +0000
Need Help With Spreadsheet Formula
View Count: 1120
| [2014-11-25 02:34:03] |
| User99690 - Posts: 6 |
|
If I want three cells AB, AD, AF on a spreadsheet to reach a certain number and be true at the same time and alert. What formula should I use because the following below is not working. =AND(AB > 5, AD > 10, AG > 10) |
| [2014-11-25 04:42:03] |
| |
|
In this formula the Row numbers are missing from the cell references: =AND(AB > 5, AD > 10, AG > 10) And you also mentioned AF but in the formula you use AG. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-11-25 18:12:12
|
| [2014-11-25 17:48:18] |
| User99690 - Posts: 6 |
|
Why do I keep getting the message below Alert Formula Error - Chart: SNSS [M] 5 Min #1 Error: #NAME? Formula: =AND(AB > 5, AD > 10, AG > 10) |
| [2014-11-25 17:50:06] |
| Sawtooth - Posts: 4181 |
|
You need a row number: =AND(AB3>5,AD3>10,AG3>10) |
| [2014-11-25 18:05:42] |
| User99690 - Posts: 6 |
|
Even When I use =AND(ID1.SG1 > 5, ID2.SG1 > 10, ID7.SG1 > 10) I get the same error message |
| [2014-11-25 18:42:35] |
| |
|
In response to post #4, this is correct. You do need to use the row numbers and we had not noticed that was missing from the cell references. Also, this formula is not valid to be used as a Simple Alert: Alert Formula Error - Chart: SNSS [M] 5 Min #1 Error: #NAME? Formula: =AND(AB > 5, AD > 10, AG > 10) Only directly within a Spreadsheet cell. This also requires proper cell references which includes the Row number: =AND(ID1.SG1 > 5, ID2.SG1 > 10, ID7.SG1 > 10) Refer to the documentation for this here: http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-11-25 18:43:01
|
To post a message in this thread, you need to log in with your Sierra Chart account: