+ Reply to Thread
Results 1 to 5 of 5

help needed in IF function

  1. #1
    Registered User
    Join Date
    11-25-2005
    Posts
    4

    help needed in IF function

    HI everyone,,

    I need to know what's wrong in this forumla:

    =IF(E5>94,"A",IF(E5>89,"A-",IF(E5>85,"B+",IF(E5>82,"B",IF(E5>79,"B-",IF(E5>75,"C+",IF(E5>72,"C",IF(E5>69,"C-",IF(E5>59,"D",IF(E5>0,"F",))))))))))

    ==============
    I need your help as soon as possible.



    Thank you

  2. #2
    Guest

    Re: help needed in IF function

    Hi

    Have a look at this:
    http://www.cpearson.com/excel/excelF.htm#Grades

    It should help you to sort it out. The reason your formula is not working is
    because you are only allowed 7 nested IFs.

    Hope this helps!
    Andy.

    "DaredEvil590" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > HI everyone,,
    >
    > I need to know what's wrong in this forumla:
    >
    > =IF(E5>94,"A",IF(E5>89,"A-",IF(E5>85,"B+",IF(E5>82,"B",IF(E5>79,"B-",IF(E5>75,"C+",IF(E5>72,"C",IF(E5>69,"C-",IF(E5>59,"D",IF(E5>0,"F",))))))))))
    >
    > ==============
    > I need your help as soon as possible.
    >
    >
    >
    > Thank you
    >
    >
    > --
    > DaredEvil590
    > ------------------------------------------------------------------------
    > DaredEvil590's Profile:
    > http://www.excelforum.com/member.php...o&userid=29085
    > View this thread: http://www.excelforum.com/showthread...hreadid=488117
    >




  3. #3
    Bob Phillips
    Guest

    Re: help needed in IF function

    You have too many nested functions, so this approach cannot work.

    Try

    =VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
    A-";95,"A"},2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "DaredEvil590" <[email protected]>
    wrote in message
    news:[email protected]...
    >
    > HI everyone,,
    >
    > I need to know what's wrong in this forumla:
    >
    >

    =IF(E5>94,"A",IF(E5>89,"A-",IF(E5>85,"B+",IF(E5>82,"B",IF(E5>79,"B-",IF(E5>7
    5,"C+",IF(E5>72,"C",IF(E5>69,"C-",IF(E5>59,"D",IF(E5>0,"F",))))))))))
    >
    > ==============
    > I need your help as soon as possible.
    >
    >
    >
    > Thank you
    >
    >
    > --
    > DaredEvil590
    > ------------------------------------------------------------------------
    > DaredEvil590's Profile:

    http://www.excelforum.com/member.php...o&userid=29085
    > View this thread: http://www.excelforum.com/showthread...hreadid=488117
    >




  4. #4
    Registered User
    Join Date
    11-25-2005
    Posts
    4
    thanks guys for ur help

    it really worked.


    thanks

  5. #5
    Registered User
    Join Date
    11-25-2005
    Posts
    4
    Hi Bob Phillips,

    I used the formula that you gave it to me

    =VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
    A-";95,"A"},2)

    everything is okay, but the problem is when I insert a grade between( 90-95) which suppose to get me ( A-) i got an error.

    please help me to solve this problem, soon.


    thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1