Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Nested IF Function in Excel

  • 02-06-2007 2:47pm
    #1
    py2006
    Registered Users, Registered Users 2 Posts: 9,844 ✭✭✭


    Hi folks,

    If I gave this a bit of thought I could probably figure it out but why would I do that when I could get somebody to do it for me? :rolleyes:

    Basically, I am doing up a little spreadsheet for exam results. I basically want a nested IF Function that will say whether a student got a Pass, Merit or Distinction.

    Assuming there marks are in cell D1:

    If (D1 >=50 and <=64, PASS), (D1 >=65 and <=79, Merit), (D1 >=80, Ditinction)

    You get the idea? Any ideas?

    Thanks in advance!


Comments

  • #2
    tuxy
    Closed Accounts Posts: 14,983 ✭✭✭✭tuxy


    Something like this?
    =IF(D1<=49,"Unsuccessful",IF(D1<=64,"Pass",IF(D1<=79,"Merit","Distinction")))


  • #3
    py2006
    Registered Users, Registered Users 2 Posts: 9,844 ✭✭✭py2006


    tuxy wrote:
    Something like this?
    =IF(D1<=49,"Unsuccessful",IF(D1<=64,"Pass",IF(D1<=79,"Merit","Distinction")))

    Woo Hoo, tanx!


Advertisement