Is it not possibe to insert an IF(AND..-formula into an IF(OR.-formula?

[BCB]

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

[ChemistB]

You don't need the internal IF's and shuffling your parentheses;

Please Login or Register  to view this content.

Does that work for you?

[BCB]

Hello
I'm afraid not: the same error messages pops up (regarding lack of or misplaced parentheses). Appreciate your efforts, though.
I'll try to get around the problem by a combination of the IF-formulae I already have, and find some way of putting the alternative case formula in the "0"/"FALSE" part. I vaguely remember a way of doing something like this a while ago; I just hoped the formula above - if functioning - might be a short cut.
Thanks anyway

BCB

[martindwilson]

if you want to replace DM2827=5 in

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

it needs to look like this

Please Login or Register  to view this content.

[BCB]

Thank you!
This one seems to do the trick. At least it returns the 1 or 0 (depending on conditions I have not yet sorted out).
Now remains the tricky part of brain working alone, with sorting out the numerous conditions. A few decisions to make..
But once having done that, this formula will be very useful, and save me some time as well as space in the sheet.
Thanks again.
BCB