View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Countif, Match or Sumif Formula

ISNUMBER returns a value of TRUE or FALSE. To convert these to
their numeric equivalent (1 or 0), the double negative sign is
used. It takes the negative of a negative, which coerces the TRUE
or FALSE value to numbers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Gunjani" wrote in message
oups.com...
Why the "--" before ISNUMBER

Regards

Gunjani