Support Board
Date/Time: Thu, 04 Dec 2025 00:03:50 +0000
Post From: Spreadsheet system for trading question about IF
| [2014-04-13 16:21:29] |
| Sawtooth - Posts: 4290 |
|
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)) |