Results 1 to 6 of 6

Thread: If Nesting Question

  1. #1
    Neophyte Candie's Avatar
    Join Date
    Feb 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365

    If Nesting Question



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor Quality."

  2. #2
    Neophyte Candie's Avatar
    Join Date
    Feb 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365
    This is the formula I tried to use:
    =IF(AND(E16<=C16,H16>1,"Good Job","Poor Quality"),IF(E16>C16,"Too Much Time","Poor Quality"))

    It doesn't work!!!

  3. #3
    Conjurer Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    100
    Articles
    0
    Excel Version
    2013, 2016, O365
    Try something like this:
    Code:
    =IF(H16<=1,"Poor Quality",IF(E16<=C16,"Good Job","Too Much Time"))
    Is that something you can work with?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  4. #4
    Neophyte Candie's Avatar
    Join Date
    Feb 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365

    If Nesting Question

    I'm being told that this is the first piece =IF(AND(E16<=C16,H16>1),"Good Job") and this is the 2nd piece =IF(E16>C16,"Too Much Time","Poor Quality"). They work seperately with the exception that "Good Work" show up where it should and False shows up when "Good Job" isn't correct. The 2nd piece works as it should. When I try to put them together =IF(AND(E16<=C16,H16>1),"Good Job",IF(E16>C16,"Too Much Time","Poor Quality")) it doesn't work. I get an error. How would I put them together?

    Job ID Estimated Hours

  5. #5
    Conjurer Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    100
    Articles
    0
    Excel Version
    2013, 2016, O365
    From what I could see, these are the rules:
    if quality <= 1 then Poor Quality
    Therefore, anything else has quality >1
    So...
    if hours is <= estimate then Good Job
    otherwise Too Much Time

    If I'm missing something, can you post some sample data and the expected results?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Candie View Post
    This is the formula I tried to use:
    =IF(AND(E16<=C16,H16>1),"Good Job","Poor Quality"),IF(E16>C16,"Too Much Time","Poor Quality"))

    It doesn't work!!!
    The problems with the above are:
    1. The bracket that terminates the AND() function is in the wrong place, so Excel treats "Good Job","Poor Quality" as intended AND() parameters.
    2. There aren't enough nested IFs to handle the return options
    3. It seemed prudent to report it if we have both Too much time and poor quality so I have added that.

    Try this:
    =IF(AND(C16<=E16,H16>1),"Good Job", IF(AND(C16>E16,H16<=1),"Too Much Time and Poor Quality", IF(C16>E16, "Too Much Time", "Poor Quality")))

Posting Permissions

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