Support Board
Date/Time: Tue, 26 Nov 2024 06:32:59 +0000
Post From: How do I write spreadsheet code utalizing"IF"
| [2014-04-15 11:08:31] |
| 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 :) |