Support Board

Date/Time: Fri, 03 May 2024 13:21:50 +0000

Post From: How do I write spreadsheet code utalizing"IF"

[2014-04-15 11:08:31] Link To Thread - Link To Post [Go To First Post]
MotoMoto - Posts: 47
I am not sure what 'buy2' and 'buy1' means for you (do you want to send 2 separate orders), but it seems like you are simply wanting a filter. So you could separate these into different columns and compare them.... or use if(or(and(A),and(B)),and(C),0) or are you looking for this. if(or(and(A),and(B)),buy2,if(and(C),buy1,0)) breaking this down 'if(or(and(A),and(B))' is true --> buy2 if not, then run the next if statement 'if(and(C)' is true ---> buy 1 Then buy1, and buy2, mean different things such as - buy quantity of 3, buy quantity 1 if existing position is already open. Hope that is not confusing :)