+ 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,573

    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)

Similar Threads

  1. Multiple Argument for IF statement
    By ExcelDummy77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2014, 04:10 PM
  2. [SOLVED] Complex functional argument help needed!
    By ExcelDummy2 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-28-2013, 09:27 AM
  3. IF Statement for copying multiple cells if argument true
    By saeed9313 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 01:44 AM
  4. Problems with argument formula
    By DCMADiva87 in forum Excel General
    Replies: 2
    Last Post: 08-04-2010, 11:46 AM
  5. selecting first correct argument in if statement
    By gss in forum Excel General
    Replies: 4
    Last Post: 06-09-2009, 02:27 AM
  6. Using first correct argument in if statement
    By gss in forum Excel General
    Replies: 5
    Last Post: 06-03-2009, 04:23 PM
  7. [SOLVED] Function (array argument, range argument, string argument) vba
    By Witek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 11:07 AM

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