Support Board
Date/Time: Fri, 21 Nov 2025 02:40:08 +0000
Post From: Help with spreadsheet trading ( double heiken ashi system )
| [2018-04-05 03:05:12] |
| User651753 - Posts: 77 |
|
could you please give me an example of IFOR I couldn't find it in the link you shared I am looking for if the price is higher then MA+20 or lower then MA-20 = 1 so if either outcome is true -1 while =AND both have to be true. at the moment I've been getting around it with this =if(E3>AA3,1,if(E3<AC3,1,0)) I am guessing it hase to look like this =IFOR( condition 1 , condition 2 , if either or both are correct =1, if both are NOT correct =0) |