+ Reply to Thread
Results 1 to 5 of 5

IF statement together with AND and OR and Else workbook

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    IF statement together with AND and OR and Else workbook

    Dear community,

    Good Afternoon all. The weather is clearing up here in Kent so may be able to get the axe out and split some logs after all, save burning the furniture!

    I hope this post conforms with forum rules as I am asking for directions rather than help with a specific problem.

    I am currently focusing on learning the above (IF with AND OR or ELSE).

    In the past I have DL'd workbooks from Contextures or Excelisfun as I find workbooks useful.

    However, in the case of (IF with AND OR or ELSE) I am finding it difficult to locate a workbook online.

    If anybody has one or can recommend a site, please can you let me know.

    All the bestt
    Darren
    Last edited by Blake 7; 10-23-2010 at 09:33 AM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: IF statement together with AND and OR and Else workbook

    Hello Darren,

    are you discussing VBA or functions?

    In both cases, the Excel help files are a great start.

    With regards to functions, there is no ELSE function, so we can scrap that.

    The syntax for IF() is

    IF(<condition>, <True action>, <False action>)

    In the <condition> bit, you can put in any combination of AND() or OR(). The main point is that the <condition> results in either True or False.

    For an AND() statement, all elements of the AND() function must be True so the whole AND() statement results in true.

    For an OR() statement, at least one of the elements must resolve to True for the function to return True.

    You can nest a fair amount of AND and OR

    The concept might be easier to explain with a concrete example that you are currently working with, so please feel welcome to upload a workbook with some of your challenges.

    cheers,

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: IF statement together with AND and OR and Else workbook

    EDIT - Functions not VBA.

    Danke schon Teylyn, for taking the time to help.

    Your response was clear and helpful - I shall C and P it into my Excel help folder!

    I dont have a concrete example at the moment as I am simply trying to learn the IF function and the operators which go with it! When I do i'll be sure to post!

    I have managed to find workbooks on Index Match, Indirect, OFFSET, SUMCELLS amoungst others but IF, (the statement I MOST use), am finding it difficult to find a decent source! Typical!

    All the best.
    Darren
    Last edited by Blake 7; 10-23-2010 at 07:48 AM.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: IF statement together with AND and OR and Else workbook

    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: IF statement together with AND and OR and Else workbook

    Hi Martin - How's it going? Hope all well with you.

    Just come in from chopping logs! jeez i'm getting old!

    Thanks for the link mate. I'll C and P the data into a sheet and follow the example.

    Hope you have a good day.
    Darren

+ 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