Thanks Mr Vijay,
Using -- operator, I am able to convert Numeric Characters to Numeric
value. (Example : entered =--a1 in cell A2 to convert the
character contents from cell a1).
Similerly, is there any similler operator is available to convert it back
to character except single / double Quote.
Thanks Mr Vijaykumar.
Regards
Eugene
On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR wrote:
> Respected Eugene Bernard,
>
> The double negative is used to "coerce," as we say, a non-number type into
> a
> number type. Since only a number (not text, boolean, error value, etc.)
> can
> follow a mi
Respected Eugene Bernard,
The double negative is used to "coerce," as we say, a non-number type into
a
number type. Since only a number (not text, boolean, error value, etc.) can
follow a minus sign, one minus sign forces the coercion to a number. The
other just reverses the sign change caused by
Hi Prince,
What is the use of -- in the formula mentioned by you.
The result is OK, but I do not find this of syntax in Excel Help.
Please elaborate.
Regards
Eugene
On Tue, Jun 4, 2013 at 5:16 PM, Prince wrote:
> may be it can help you.
>
> =SUMPRODUCT(--(I9:I17="Black"),--(H9:H17="Cars"),(
