Support Board
Date/Time: Mon, 25 Nov 2024 07:40:28 +0000
Post From: Spreadsheet, formula including all session bars
| [2024-02-18 13:09:47] |
| User440951 - Posts: 50 |
|
Hi, I would like to create a formula in a spreadsheet that gives me an alert when in the session, 10:00:00 p.m. to 9:59:59 p.m. for me, the price has touched two very specific levels. To keep it simple in this request, 1 will be true and 0 false. I tried this : =IF(AND(CROSSOVER(ID0.SG4, ID2.SG1), CROSSOVER(ID0.SG4, ID2.SG2)), 1, 0) Or this =IF(AND(AND(FRACTIME(J41)>=TIME(22, 00, 00, 750), FRACTIME(J41)<TIME(21, 59, 59, 250)), CROSSOVER(ID0.SG4, ID2.SG1), CROSSOVER(ID0.SG4, ID2.SG2)), 1, 0) But it always returns false to me even though the conditions are met in the sessions. I can't find the solution, could you help me? |