+ Reply to Thread
Results 1 to 4 of 4

Help needed for a nested IF function

  1. #1
    Registered User
    Join Date
    01-15-2016
    Location
    Cincinnati,OH
    MS-Off Ver
    Professional Plus 2010
    Posts
    2

    Post Help needed for a nested IF function

    Greetings
    I have a set of data that I need to calculate in Excel and come up with one specific answer.
    An example of the data is:
    Monthly Hr Quotient Effective Hr Quotient Exceptional Hr Quotient Score 0-10 MR Performance Analysis
    97.30 2062.50 3281.25
    4291.33 2062.50 3281.25
    2805.91 2062.50 3281.25
    823.30 2062.50 3281.25

    I need to determine if their score per row is 0, 5, 10.
    The logic for the decision is
    Number Feedback
    10 Exceptional
    5 Effective
    0 Ineffective
    #N/A
    #N/A #N/A

    I tried using nested IF statements: =IF(A2<B2,"0",IF(A2>C2,"10",IF(A2>A2,IF(F2<C2,"5","NA"))))

    Which worked fine for the results of 0 and 10 but the mid-range result is #NAME?

    Any suggestions on how to resolve that problem?
    Your cooperation and time is much appreciated…
    Kevin

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,543

    Re: Help needed for a nested IF function

    Try the formula this way:
    Please Login or Register  to view this content.
    The IF(A2>A2 part was throwing it off as that would always evaluate to false (a value can't be smaller/larger than itself) and so it was bypassing the IF(F3<C3,"5","NA") part.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    01-15-2016
    Location
    Cincinnati,OH
    MS-Off Ver
    Professional Plus 2010
    Posts
    2

    Re: Help needed for a nested IF function

    BIG THANKS JeteMc!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,543

    Re: Help needed for a nested IF function

    You're Welcome, and thank you for the feedback and for marking the thread 'Solved'. Next visit consider using the "Go Advanced" feature to upload your spreadsheet instead of just data, will save you and the person(s) helping you time and effort. Hope that you have a good day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested IF function needed
    By Petsi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-20-2014, 01:46 PM
  2. Help with Nested IF Formula Needed
    By financeanalyst in forum Excel General
    Replies: 4
    Last Post: 04-03-2014, 10:18 AM
  3. [SOLVED] Nested IF or IF(AND formula needed please
    By rwalker1052 in forum Excel General
    Replies: 3
    Last Post: 11-26-2013, 03:58 AM
  4. [SOLVED] Nested if statements needed?
    By khenry67 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 04:46 PM
  5. Nested IF function (urgent help needed)
    By HJalal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 11:59 AM
  6. Nested If Formula Help Needed
    By johnsor1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2012, 09:34 AM
  7. help with nested if() problem needed
    By whitegrass in forum Excel General
    Replies: 3
    Last Post: 10-15-2009, 02:16 PM

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