+ Reply to Thread
Results 1 to 5 of 5

Multi if condition

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    922

    Multi if condition

    Hello

    I am looking for vba code for use 2 if conditions

    example this my code
    Please Login or Register  to view this content.
    if i want say, if a = 1 and b = 2, then ....

    how can i do it ?
    i use this code but its not working

    Please Login or Register  to view this content.

  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
    44,963

    Re: Multi if condition

    Try
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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 Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,517

    Re: Multi if condition

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  4. #4
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    922

    Re: Multi if condition

    Thanks, solved
    AND
    Last edited by Undo; 07-29-2019 at 09:43 AM.

  5. #5
    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
    44,963

    Re: Multi if condition

    You're welcome. Thanks for the rep.

+ 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. [SOLVED] if condition in multi case.....
    By amarjeet.it in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2017, 03:12 AM
  2. multi condition value 1 or value 2 or...value n
    By erkamu in forum Excel General
    Replies: 6
    Last Post: 02-09-2017, 07:21 AM
  3. [SOLVED] Multi condition lookup
    By Suleiman Farah in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-22-2015, 01:10 PM
  4. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 AM
  5. Multi Condition SUM
    By newone210 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2006, 01:18 PM
  6. Multi-condition vlookup
    By Hobbeson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] Multi-condition vlookup
    By Hobbeson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2005, 10:05 PM

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