+ Reply to Thread
Results 1 to 3 of 3

Problems with IF statement where more than 1 argument is needed

  1. #1
    Registered User
    Join Date
    07-22-2005
    Posts
    15

    Problems with IF statement where more than 1 argument is needed

    My intention is to create a formula that states if cell value (AZ2) is 0 then return "Not Applicable", If the Cell value is between 1 and 96 then return "Training" and if the cell value exceeds 96 then return "Trained".
    This is the formula I have been working on but wont be accepted. Where am I going wrong?

    =IF((AZ2>=96, "Trained"), IF(AND(AZ2>96, AZ2<0), "Training", "Not Applicable"))

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,151

    Re: Problems with IF statement where more than 1 argument is needed

    Your middle bit there is saying if AZ2 is both greater than 96 AND less than zero, which cannot be the case.

    As you have tested for AZ2 being greater than or equal to 96 in your first IF, then if the second IF is evaluated it must be because AZ2 is less than 96, so you don't need to test for that. Try it this way:

    =IF(AZ2>=96, "Trained", IF(AZ2>0, "Training", "Not Applicable"))

    Hope this helps.

    Pete

    EDIT: you also had some brackets in the wrong place.
    Last edited by Pete_UK; 08-27-2015 at 04:57 PM.

  3. #3
    Registered User
    Join Date
    07-22-2005
    Posts
    15

    Re: Problems with IF statement where more than 1 argument is needed

    Thanks, Ill give it a go. Been a while since I used Excel and the grey matter is a bit rusty.

+ 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