1. Banners
    Dismiss Notice

Excel If Statement

Discussion in 'Technology' started by trance_fan, Feb 17, 2005.

Users Viewing Thread (Users: 0, Guests: 1)

  1. trance_fan

    trance_fan Registered User

    Joined:
    Nov 7, 2002
    Messages:
    9,079
    Likes Received:
    0
    Excel If Statement

    Just knocking up a spreadsheet.

    One of the cells, which will indicate pass or fail, relies on a certain figure being over 40.

    However, since i am making a template, at the minute most of the values are 0 as there are no figures entered, so "fail" is shown.

    I only want pass or fail to be shown if a certain cell has a value present. (or simply to be greater than 0 before its used)

    How can I do this? Nested If? If And?

    Cheers :)
    trance_fan, Feb 17, 2005
    #1
  2. 1615634792921.png
  3. moss

    moss Registered User

    Joined:
    Feb 1, 2004
    Messages:
    227
    Likes Received:
    0
    Location:
    South Shields
    Just had a play about, I think this should do what you want...

    =IF(ISBLANK(A1),"",IF(A1<5,"Fail",IF(A1>=5,"Pass")))

    A1 obviously being the cell of the exam result, and I just used 5 as an example pass level.

    Hope this helps :)
    moss, Feb 18, 2005
    #2
  4. trance_fan

    trance_fan Registered User

    Joined:
    Nov 7, 2002
    Messages:
    9,079
    Likes Received:
    0
    excellent mate, cheers :)
    trance_fan, Feb 18, 2005
    #3

Share This Page