Re: [sc-dev] A question of i38759

2007-12-11 Thread Eike Rathke
Hi Lvyue, On Tuesday, 2007-12-11 10:35:18 +0800, Lvyue wrote: I want to ask if there is no numeric value, but string value in a cell, range or matrix, should MIN/MAX return 0? Yes. Only if there are no other numeric values that would result in a different min/max, of course. Short

[sc-dev] A question of i38759

2007-12-10 Thread Lvyue
hi, Eike Thank you for the fast reply. I want to ask if there is no numeric value, but string value in a cell, range or matrix, should MIN/MAX return 0? If that, then what is the difference between MIN/MAX and MINA/MAXA? I think one parm can be considered empty only if there is not any value,