+ Reply to Thread
Results 1 to 3 of 3

Macro If multiplie criteria

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Lithuania
    MS-Off Ver
    2010
    Posts
    4

    Macro If multiplie criteria

    excel 2010

    Hey,

    I don't know how to write macro "if" command with few criterias for different cells.
    What I want to do:

    If A1 = 0 and B1 <> 0 and C1 <> 0 then

    End if

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Macro If multiplie criteria

    I think that's pretty much it,
    Please Login or Register  to view this content.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Lithuania
    MS-Off Ver
    2010
    Posts
    4

    Re: Macro If multiplie criteria

    One more question.

    How to write:
    If ("A1").value = (there is nothig in this cell)

+ 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. Apply Absolute Reference to multiplie cells
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-29-2013, 12:16 PM
  2. vlookup- getting info from multiplie sheets
    By putitwhere in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-01-2013, 12:44 PM
  3. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  4. [SOLVED] Formula to multiplie cells and then add up
    By D-smoke in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-16-2012, 08:19 AM
  5. [SOLVED] Finding data based on multiplie criteria
    By Eemmai in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2012, 07:41 AM

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