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?