# IF(AND(... Function

1. ## 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")

2. ## Re: IF(AND(... Function

What do you want from the data

3. ## Re: IF(AND(... Function

Hello,

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. ## 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.

5. ## 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. ## 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. ## if function

hi

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

8. ## Re: IF(AND(... Function

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.

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.

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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