Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 09:56:42 +0000
Post From: How do I write spreadsheet code utalizing"IF"
| [2014-04-15 13:09:00] |
| User14682 - Posts: 83 |
|
I want to buy 2 contracts if this is true =OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3)) And buy 1 contract based on the next code only if the first line is true AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3) |