Results 1 to 4 of 4

Thread: IF with AND

  1. #1
    Acolyte tigerdel's Avatar
    Join Date
    Aug 2012
    Location
    Cambridgeshire
    Posts
    40
    Articles
    0
    Excel Version
    Office 365

    IF with AND



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All

    I am try get a text box to contain a value based on the result of 2 comboboxes:

    CmbRole contains text
    CmbSDate contains a date

    txtCourse needs a value based on the result of the value in both cells

    have tried:



    If CmbRole = "X" and CmbSDate = "Y" thenTxtCourse.value = "Z"

    without any success

    Any ideas??

    Thanks

    D

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    In what way was that not a success?

  3. #3
    Acolyte tigerdel's Avatar
    Join Date
    Aug 2012
    Location
    Cambridgeshire
    Posts
    40
    Articles
    0
    Excel Version
    Office 365
    TxtCourse is empty

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    Then either CmbRole is not "X" or CmbSDate is not "Y".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •