array formula
 

hello,
let's say i have data in the range (E2:E88), i want to calculate the
standard deviation in cell "E89" , i entered this formula
={STDEV(IF(ISERROR(E2:E88),"",E2:E88))}, i want to modify this formula to not
just skip errors but blanks and values that are bigger than 100 also, can
anyone help me?

array formula
 

=STDEV(IF((NOT(ISERROR(E2:E88)))*(E2:E88<=100),E2: E88))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"nada" wrote in message
...
hello,
let's say i have data in the range (E2:E88), i want to calculate the
standard deviation in cell "E89" , i entered this formula
={STDEV(IF(ISERROR(E2:E88),"",E2:E88))}, i want to modify this formula to
not
just skip errors but blanks and values that are bigger than 100 also, can
anyone help me?