Dear All,

I used following formula both as normal & array -

=IF(AND($L$2:$L$98=0,$M$2:$M$98=0),STDEV(B2:B98),"-")

The normal formula is returning #VALUE while array one is returning " - ".

Please help where my problem lies.

Regards,

Dastgir