Nested IF formula

Originally Posted by :) Sixthsense :)

I am not aware the usage of STDEV function, but in general term the formula should be constructed like the below

Array Formula - Requires Ctrl+Shift+Enter

Formula:

=STDEV(IF(($L$2:$L$98=0)*($M$2:$M$98=0),(B2:B98)))

s,

Dear Sixthsense,

As we use * for AND use, is there any symbol which can be used for other logics such as OR , NOT etc.

Regard

Dastgir