Support Board
Date/Time: Tue, 26 Nov 2024 06:51:48 +0000
Post From: Spreadsheet system for trading question about IF
| [2014-04-13 16:21:29] |
| Sawtooth - Posts: 4120 |
|
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)) |