EXTRACT and ALL functions

[oscarse]

Maybe I am misinterpreting the logic here?

I was expecting to do a
=EXTRACT(<objecttoextract>,
(<logicalexpr1> AND <logicalexpr2>))

Basically EXTRACT only if 2 conditions are true

The compiler comes back and says its wanting a singular Logical expression ... so I went into the functions and couldn't find an AND ... ALL() sounds like an AND but I tried

=EXTRACT(<objecttoextract>,
ALL(<logicalexpr1>,<logicalexpr2>))

The compiler doesn't like this either can someone please set me on the right track.

 

[SeriesConsumer]

Logical AND is expressed by a single & sign (locigal OR by |).