Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula where s36 = 1 if a10=s7 and c10=any value?
Solved by G. J. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 21/07/2018 - 03:25
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
User 21/07/2018 - 03:26
Hello
Excelchat Expert 21/07/2018 - 03:27
I've read your post. If I understand it correctly, you want cell S36 to return 1 if cell A10 is equal to cell S7 and cell C10 has a value. Is this correct? :)
User 21/07/2018 - 03:27
Yes that is correct.
User 21/07/2018 - 03:28
It can be be cells in a closer range if that helps but yes that is correct.
Excelchat Expert 21/07/2018 - 03:28
Okay nice! Just to clarify, what should cell S36 return if the conditions are not met? Should it just be blank?
User 21/07/2018 - 03:28
1 if all conditions are met, 0 if they are not.
Excelchat Expert 21/07/2018 - 03:29
Okay, noted on that. In cell S36, please enter the following formula:
Excelchat Expert 21/07/2018 - 03:29
=IF(AND(A10=S7,C10>0),1,0)
Excelchat Expert 21/07/2018 - 03:30
Please ping me up if the formula works correctly. Thanks!
User 21/07/2018 - 03:31
That worked. I have one more variation of the problem if it is possible.
Excelchat Expert 21/07/2018 - 03:31
Okay i see. I can help with that since it's related to our earlier problem. :)
User 21/07/2018 - 03:32
Can we do the same thing but make the conditions, if (A10=S7 and C10=YES) or (A10=S7 And d10=Any Value)
Excelchat Expert 21/07/2018 - 03:33
Yes, we can do that. Let me revise our earlier formula to integrate your new conditions.
User 21/07/2018 - 03:33
So is it possible to combine the equation you gave me with a or statement where A10=S7 and C10=YES?
Excelchat Expert 21/07/2018 - 03:33
That is correct. :)
Excelchat Expert 21/07/2018 - 03:33
And you're right in making use of the OR statement to include your new conditions. :)
Excelchat Expert 21/07/2018 - 03:34
Please see below the revised formula:
Excelchat Expert 21/07/2018 - 03:34
=IF(OR(AND(A10=S7,C10="YES"),AND(A10=S7,D10<>"")),1,0)
Excelchat Expert 21/07/2018 - 03:35
So as you have mentioned, we included an OR statement that encompasses our two AND functions. So if any of the AND statements return a TRUE logic, the formula will return a 1. Otherwise, it will be 0. :)
User 21/07/2018 - 03:36
Awesome that worked perfectly.
Excelchat Expert 21/07/2018 - 03:36
Do you have clarifications with the solution provided? ;)
User 21/07/2018 - 03:37
For any other questions I assume I need to pay for a subscription?
Excelchat Expert 21/07/2018 - 03:38
Oh yes, that will be correct. You can avail of a monthly submission and you'll be entitled with unlimited session. For additional info, you can refer here: https://www.excelchat.co/pricing/personal
User 21/07/2018 - 03:38
Sounds good. Thank you very much!
Excelchat Expert 21/07/2018 - 03:38
Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.