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

    Re: Double If Statement Help

    Not tested:

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

    Regards
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  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,400

    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.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  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