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
What do you want from the data
What is your required output
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"
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] .
Yes you truly are the forum guru !! Thankyou very very much for your time. I wish I could figure these type of problems out !
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.
hi
friends! I need your help to develop a formula in excel sheet.
please see attachment.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks