t: $$Excel-Macros$$ Could you please explain why are we using -- in
this formula
Hi Friends,
Could you please explain why are we using -- in this formula.
=IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(--TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1)
,ROW(INDIRECT("1:"&ROW()-1))/ROW(IN
Thank you very much my dear friends, for yours quick reply.
Thanks
N.Sundarvelan
9600160150
On Wed, Jan 4, 2012 at 12:12 PM, NOORAIN ANSARI wrote:
> Dear Sundarvelan,
>
> The -- is used as an unary operator to convert a boolean value ie,
> TRUE/FALSE in to 1/0.
>
> So to negate this, we use un
Dear Sundarvelan,
The -- is used as an unary operator to convert a boolean value ie,
TRUE/FALSE in to 1/0.
So to negate this, we use unary operator -- with TRUE or FALSE to give 1 or
0
We can also use ++ ,0+1,*1
In fact you can also use a multiplier or a divisor of 1
--
Thanks & regards,
Noor
Hi Friends,
Could you please explain why are we using -- in this formula.
=IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)),"",OFFSET($A$1,MATCH(0,MMULT(
--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),RO
