Excel Homework Help

[Crash-n-Burn]

If anybody could help me I would really appreciate it. I searched the intertubes to no avail.

What formula would let me search through a column A and find how many numbers less than 0.5 are followed by one greater than 0.5?

Thanks.

 

[wordmunger]

Use an if statement in column b to check if the cell to the left is less than 0.5 and the one below it is greater than 0.5. Have it return a value of 1 if true and zero if false. Then sum column b.