LinkBack URL
About LinkBacks
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)))
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)))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
s,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)))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks