Hello,
I know that if I wanted to include all nonzero numbers that I am suppose to use the ISNUMBER function but how do I implement it with other function such as STDEV(A1:A30).
That column has numbers I want to find what their standard deviation is but it also has zeros that I dont want to use in the calculation. Please...anyone has an answer?
I know that if I wanted to include all nonzero numbers that I am suppose to use the ISNUMBER function but how do I implement it with other function such as STDEV(A1:A30).
That column has numbers I want to find what their standard deviation is but it also has zeros that I dont want to use in the calculation. Please...anyone has an answer?