What is indicator for range? I thought it is ":", but it doesn't work for me.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Khoshravan" wrote:

Problem is with ":" as span indicator. My Excel doesn't accept ":" as in
Max(A1:A2960). Where should look in Excel to fix this problem
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Khoshravan" wrote:

I have a column of 2960 numbers (amplitudes of an earthquake wave). I want to
find the max and min of them, max and min functions return zero. I doubted
maybe the data are text, but multiplication of a single cell in a multiplier
(let say 2), returns correct result. Sum on all data doesn't work as well
(returns zero) but sum of two cells works correctly. Also x-y plot returns
zero value for Y. I checked the format of data in cell command. the format is
number. Also I checked Option to see if automatic calculation is turned off,
but it on.
Really confused. This is the first time to face such a malfunction. What
else could be considered to be checked?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan