+ Reply to Thread
Results 1 to 4 of 4

Double If Statement Help

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    59

    Post Double If Statement Help

    Hello,
    I was trying to change the following code to include another statement.


    Please Login or Register  to view this content.
    This code says currently that IF I5=GV and J5=Error, output "input required"

    I want to include IFI5=GV and J5=Defective, then output "input required"

    Thanks,
    -Vargs
    Last edited by vargs; 12-08-2010 at 09:58 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,850

    Re: Double If Statement Help

    Not tested:

    =IF(AND(I5="GV",OR(J5="Error",J5="Defective")),"Input Required", " ")

    Regards

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Double If Statement Help

    Hi
    When you say you want to add another statement, do you mean that you want to include the J5="Defective" as well as the J5="Error"?
    Also when you say "Error", do you literally mean the text "Error" or by error are you referring to the evaluation of a formula which returns an error like say #N/A?
    I'll assume "Error" is text. So presumably

    Please Login or Register  to view this content.
    HTH. If not please be more explicit with your requirement.

  4. #4
    Registered User
    Join Date
    06-18-2010
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: Double If Statement Help

    Thank you for the quick reply TMShucks and Richard Buttrey.

    I used the code in TMSchucks post and it worked perfectly.

    Thank you so much for both your replies.

    Sincerely,

    -Vargs

+ 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