+ Reply to Thread
Results 1 to 3 of 3

Multiple Arguments in IF

  1. #1
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Multiple Arguments in IF

    Hi again,
    I would like to ask for help on some argument
    How do i go about this scenarion?

    Supposed on A1 I have numbers 1 to 100

    On A2, I want a return with the following choices. Nearing Review, Compliant, and Out of Compliance

    The argument will be:
    If A1 > 10 Return must be Compliant
    If A1 < 10 Return must be Nearing Review
    If A1 = #NUM! Return must be Out of Compliance

    Can this be done? Looking forward to your response. Thank you.

    Regards,
    Andrew
    Last edited by Andrew.Trevayne; 11-24-2010 at 04:00 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Help on 3 Arguments

    Perhaps:

    Please Login or Register  to view this content.
    note: I assume =10 is "nearing review" if compliant change >10 to >=10

  3. #3
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Re: Multiple Arguments in IF

    This is just perfect. Thank you very much.

+ 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