MS Excel Formula Help

Discussion in 'The BS Topic' started by HurtHorseZ28, Jun 1, 2015.

  1. HurtHorseZ28

    HurtHorseZ28 Veteran Member Lifetime Gold Member

    Messages:
    4,529
    Likes Received:
    1
    Joined:
    Jul 29, 2000
    Location:
    Philadelphia Area, PA, USA
    I am trying to create a formula to calculate progress over time and can't get it to work.

    For example:

    Student A earned a 50 on the beginning of the year test, a 75 on the mid-term and a 100 on the final.

    I am looking for an IF statement that would report back as TRUE if the final>mid-term>beginning of the year test. I'd also like it to report back as FALSE if that condition is not met.

    Thanks!
     
  2. Todd80Z28

    Todd80Z28 Moderator Staff Member Lifetime Gold Member

    Messages:
    11,809
    Likes Received:
    411
    Joined:
    Jun 11, 2002
    Location:
    Northern VA
  3. 76_TypeLT

    76_TypeLT Veteran Member Lifetime Gold Member

    Messages:
    6,389
    Likes Received:
    144
    Joined:
    Jul 26, 2008
    Location:
    Houston, TX
    Just say =IF(AND("Midterm > Beginning","Final > Midterm"), TRUE, FALSE)

    Only one outcome results in a TRUE result, so all others are FALSE.
     
  4. HurtHorseZ28

    HurtHorseZ28 Veteran Member Lifetime Gold Member

    Messages:
    4,529
    Likes Received:
    1
    Joined:
    Jul 29, 2000
    Location:
    Philadelphia Area, PA, USA

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.