Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 11:37:51 +0000



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

[2014-04-13 16:55:12]
User14682 - Posts: 83

Buy Example:

If this happens - (AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3,AI3>AK3,AI3>AM3)

2 lots

Then this happens - (AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3,AO3>AQ3)

1 lots

Any help would be greatly appreciated

Sells are exactly the opposite and how do I include the sells?

My current buy code not including "IF"

=OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3,AI3>AK3,AI3>AM3),AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3,AO3>AQ3))