| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array Formula? | Excel Worksheet Functions | |||
| HELP !!! I have a ARRAY Formula HELP !!! | Excel Discussion (Misc queries) | |||
| Array Formula help pls. | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Threaded Mode
