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.
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
Thanks Mr Vijaykumar.
Regards
Eugene
On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com 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
may be it can help you.
=SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))
Regards
Prince
On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:
Hi Team,
i want to get formula to find Total value of cars with black color only.
pls help.
Rgds,
Prabhakar
--
Are you
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 prince141...@gmail.com wrote:
may be it can help you.