Excel Homework Help

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

  1. Crash-n-Burn macrumors regular

    Joined:
    Jan 9, 2007
    #1
    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.
     
  2. wordmunger macrumors 603

    wordmunger

    Joined:
    Sep 3, 2003
    Location:
    North Carolina
    #2
    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