Excel Homework Help

Discussion in 'Community Discussion' started by Crash-n-Burn, Aug 28, 2008.

  1. Crash-n-Burn macrumors regular

    Jan 9, 2007
    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?

  2. wordmunger macrumors 603


    Sep 3, 2003
    North Carolina
    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.

Share This Page