Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 23:20:09 +0000

How to Post a Message for Support

Post From: Spreadsheet system for trading question about IF

[2014-04-13 16:21:29]
[Go To First Post]
Sawtooth - Posts: 3982
Try this (in cell J26):

IF(OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3)),2,IF(AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3,AO3>AQ3),1,0))