Support Board
Date/Time: Sat, 23 Nov 2024 08:40:07 +0000
Post From: Audible alert on Spreadsheet study when cell value exceeds a certain number
| [2024-09-06 01:54:00] |
| trader2017 - Posts: 98 |
|
I have a sheet in the workbook that I created with the spreadsheet>add spreadsheet command called “Profit.” On that spreadsheet is where I reference all the other sheets’ data, for example: =Sheet21!$J$10. That Profit spreadsheet has all the calculations and is not linked to a chart directly the way Sheet21, Sheet22, Sheet23 etc. is, so all the cells are blank until I start to reference data or add formulas to the cells. From there is where I’m trying to determine when a cell value is over $100. The cell I’m using for the total is $A$6 so using your example I wrote =$A$6 > 100 in cell $I$6 on the Profit spreadsheet. Assuming that cell $A$6 is $101 then the $I$6 cell will have a returned value of 1. I don’t understand what you mean by: “Then you can use the subgraph for that column in an alert condition somewhere.” How do I reference the returned value of 1 in cell $I$6 from my Profit spreadsheet to set an audible alert that will continue to play as long as the value is over $100. Thank you for your help. |