Usually, when I horse around with different combinations of the IF(AND...-formulae, it's just a matter of patience and time before they click into place. Not this time.
I may have overlooked a parenthesis or slipped a tab or something, but the error message seems somewhat coincendental in its highlighting of places in the formula - now here, now there. Although I have quite a few functioning combinations of these (some of them ridiculously long), they are confined to the pure IF- and IF(AND-variety. So they may not be meant to be combined in the way I tried. Thought I'd ask here before I dive into the mass of combinations I already have.
First I cut the AND-part from an IF(AND(OR-formula, like this one
=IF(AND(B69=10;OR(C69=5;D69=2));1;0)
into something like this -
=IF(OR(DM2827=5;DO2827=7;DP2827=9);1;0)
- to seek out a range where just one out of many conditions are met. Works fine as such.
The trouble starts when I try to replace one of the "sub-conditions", the DM2827=5, for instance, with an IF(AND-formula.
Something like this:
=IF(OR(IF(AND(DI2822<DI2821;DF2822>DF2821);(IF(AND(DI2822<DF2821;DF2822>DI2821);1;0)))
This one would've served it's purpose perfectly, if it would only work. Does anybody know what's wrong with it - or if it's at all possible?
Thanks in advance
BCB
Bookmarks