Nel post *Jay* ha scritto:
Well it would be *even* if the 0 string was recognised as a number,
with it being zero, but I know what you mean - 'Number' Text strings
aren't recognised as numbersand skipped like nulls. However, can you
explain this:
A4 ==> 7
A5 ==> "2"
SUM(A4:A5) gives 7 (As expected,the "2" string isn't recognised as a
num)
=A4*A5 gives 14
=SUM(A4*A5) gives 14
Why is the "2" text string not recognised as a number by the
function, but *is* when used in a direct mathematical operation,
A4*A5 ?
-Jay-
Because Excel do an implicit conversion, when you use strings as arguments
in calculation Excel try to "translate" the strings in numbers, but the
function don't try to do this translation, because they don't have the
values , just the references, so they use the range as they are. But if you
put a string inside the SUM function you will be surprised, because Excel
now do the translation, so, for example =SUM("22",5) returns 27.
Also if you input A1 ==> =5<6, A2 ==> 6 and the try to sum, if you do:
=SUM(A1:A2) the results would be 6, but if you do =A1+A2 you will have 7 and
also if you do SUM(5<6,6) you will have 7.
This is because generally speaking functions inputs are references, not
values, but if you input values in a function, the function would try to
translate that value in a number.
--
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy