View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn Kevin Vaughn is offline
external usenet poster
 
Posts: 111
Default count cells that begin with specific text

Yeah, I should have gone back and rephrased the part where I was talking
about that. My bad.
--
Kevin Vaughn


"Bob Phillips" wrote:


"Kevin Vaughn" wrote in message
...
BTW, I just checked with false in a cell, D2, and -D2 returned 0 (not -0)
fwiw.


That is because 0 is neither negative nor positive, so you cannot have -0.
Negative and positive is defined in relation to 0.