View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Logical operators not working with text???

Slinky <slinky_ISAT_newsguy_DOT-com wrote...
....
in the A row are below:

* * * * A * * * B
1 - * * *TTTT * *0
2 - * * TTUU * * Formula Below
3 - * * TTUU
4 - * * VVVV
5 - * * WWW
6 - * * WWW

In the B row I set B1 to zero and then type the following in cell 2:

=IF(A2=A1,B1+0,B1+1)

....

A and B are COLUMNS, not rows.

. . . the
above should put out the following in the B row - 0, 1, 1, 2, 3, 3. It
works on the first statement and everything else stays the same - 0,
1, 1, 1, 1, 1, 1, 1..


Press the [F9] key. The situation you describe is very likely due to
manual recalculation.