Support Board
Date/Time: Sat, 30 Nov 2024 02:49:11 +0000
Post From: SC does not recognize the formulas
| [2022-12-30 16:36:15] |
| Sawtooth - Posts: 4123 |
|
can you be so kind to help me describe the exact formula?
I cannot because I have no idea what cells contain what conditions. should i write OR on the second lines?
Maybe you only need to use OR and not IF.=OR(condition1,condition2) =OR(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(AM3:AM5,AW3:AW5), O3, Q3), AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(M3:M5,AV3:AV5), O3, Q3)) Date Time Of Last Edit: 2022-12-30 18:27:32
|