IF function
IF function
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: IF function

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Sally
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am a student enrolled in a technical school. I am currently studying Microsoft Excel 2000. My instructor gave an assignment. Upon completion of this assignment, I was told that one of the answers I had given was wrong. The instructor wasn't even sure how to correctly do this problem, but guessed on the answer anyway. I disagree with her answer, could you please help me. The problem is a word problem having to do with writing an IF function. Here is the problem:
    Write an IF function for cell H5 that assigns the text "Eligible" if the value in cell H12 is three times greater than the value in cell H13; otherwise the IF function assigns the text "Not Eligible".
    Please try to help me with with this problem. I really want to understand all of Excel 2000.
    Thank You

    Sally Folds

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,785
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-16 16:59, sprinkle wrote:
    I am a student enrolled in a technical school. I am currently studying Microsoft Excel 2000. My instructor gave an assignment. Upon completion of this assignment, I was told that one of the answers I had given was wrong. The instructor wasn't even sure how to correctly do this problem, but guessed on the answer anyway. I disagree with her answer, could you please help me. The problem is a word problem having to do with writing an IF function. Here is the problem:
    Write an IF function for cell H5 that assigns the text "Eligible" if the value in cell H12 is three times greater than the value in cell H13; otherwise the IF function assigns the text "Not Eligible".
    Please try to help me with with this problem. I really want to understand all of Excel 2000.
    Thank You

    Sally Folds
    I'd accept

    =IF(H12>=3*H13,"Eligible","Not Eligible")

    as an answer.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The following may be what you are after:
    =IF(H12>=H13*3,"Eligible","Not Eligible")

    HTH

    PS. Aladin is too quick for me.

    [ This Message was edited by: BabyTiger on 2002-04-16 17:10 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if it needs to be exactly and only exactly 3 times greater:
    =IF(H12=H13*3,"Eligible","Not Eligible")

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-16 16:59, sprinkle wrote:
    I am a student enrolled in a technical school. I am currently studying Microsoft Excel 2000. My instructor gave an assignment. Upon completion of this assignment, I was told that one of the answers I had given was wrong. The instructor wasn't even sure how to correctly do this problem, but guessed on the answer anyway. I disagree with her answer, could you please help me. The problem is a word problem having to do with writing an IF function. Here is the problem:
    Write an IF function for cell H5 that assigns the text "Eligible" if the value in cell H12 is three times greater than the value in cell H13; otherwise the IF function assigns the text "Not Eligible".
    Please try to help me with with this problem. I really want to understand all of Excel 2000.
    Thank You

    Sally Folds
    Hi Sally,

    Logically, if H12 is equal to 3*H13 then "Eligible." If that is not the case, then H12 is less than or greater than H13 * 3, and thus "Not Eligible."

    In Cell H5
    =IF(H12=H13*3,"Eligible","Not Eligible")

    based on the standard IF syntax
    IF(test, result if test is TRUE, result if FALSE)

    However, I can easily see where the confusion comes in. Somewhat tricky wording at first glance, for sure.

    Is H5 "Eligible" if H12 > 3*H12, meaning only if strictly greater than?
    =IF(H12>H13*3,"Eligible","Not Eligible")

    Or, "Eligible" if greater than or equal to >=?
    =IF(H12>=H13*3,"Eligible","Not Eligible")

    Based on the wording of your question, H5 is "Eligible" only when H12 is exactly 3 times H13.

    I am sure your instructor argued one of these three options, but the first choice is the one that is correct.

    Bye,
    Jay

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com