+ Reply to Thread
Results 1 to 8 of 8

IF(AND(... Function

  1. #1
    Forum Contributor
    Join Date
    10-25-2012
    Location
    Honolulu, Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    128

    IF(AND(... Function

    Hello,

    I am trying to use an IF AND function and I cannot get it to work correctly.

    What I am trying to do is the following;

    If column b = 900 and column c = 1 then True

    I have no idea why this does not work after hours of trying. Column d will read all false if I use the function:

    =IF(AND(B2:B51=900,C2:C51=1),"TRUE")

    Please see attachment
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,640

    Re: IF(AND(... Function

    What do you want from the data
    What is your required output

  3. #3
    Forum Contributor
    Join Date
    10-25-2012
    Location
    Honolulu, Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    128

    Re: IF(AND(... Function

    Hello,

    Thankyou for the reply.

    The required output would be "true" in column D.

    All I want is if the day is "Mon" (or "1", it does not matter which) and time = "900" then "true"

    (Mon = 1)

    If it does not meet the above criteria then it would be "false"

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: IF(AND(... Function

    Hello rmccain,

    The problem is with your formula in Cell C2 which at the moment reads: =IF{(A2:A37137="Mon","1")}.

    The "1" at the end of that formula, changes it to Text, hence your issue. Click in Cell C2, hit F2, and change the formula to: =IF(A2:A37137="Mon",1)and Press Ctrl+Shift+Enter.

    Now enter this formula in Cell H10, and it will return the result you want. =IF(AND(B2=900,C2=1),"True","FALSE")

    Hope that helps.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  5. #5
    Forum Contributor
    Join Date
    10-25-2012
    Location
    Honolulu, Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    128

    Re: IF(AND(... Function

    Yes you truly are the forum guru !! Thankyou very very much for your time. I wish I could figure these type of problems out !

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: IF(AND(... Function

    Hello rmccain,

    You are welcome.

    Thank you for the feedback, and your kind words.

    Also thank you for having marked this thread as solved, and for adding to my Reputation, much appreciated!

    Regards.

  7. #7
    Registered User
    Join Date
    06-18-2012
    Location
    JODHPUR
    MS-Off Ver
    Excel 2007
    Posts
    1

    if function

    hi

    friends! I need your help to develop a formula in excel sheet.

    please see attachment.
    Attached Files Attached Files

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: IF(AND(... Function

    Hello GKDADHICH,

    Welcome to the Forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

    Also, your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Thank you for your kind co-operation.

    Regards.

+ 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. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  2. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  3. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  4. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Replies: 2
    Last Post: 03-20-2009, 01:29 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