Support Board

Date/Time: Sat, 04 May 2024 02:51:19 +0000

Post From: Help with spreadsheet trading ( double heiken ashi system )

[2018-04-05 03:05:12] Link To Thread - Link To Post [Go To First Post]
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)