# Excel - IF Function Problem - Expert Solution

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

I want to show in Cell E1 YES if Cells B6-B16,B21-31,B34-38,B41-B44,B47-B58 is YES and NO if Blank or No
Solved by G. B. in 38 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 23/07/2018 - 02:00
Hi
Excelchat Expert 23/07/2018 - 02:00
Hello!
Excelchat Expert 23/07/2018 - 02:00
Welcome to Got It Pro-Excel.
User 23/07/2018 - 02:00
Just have a quick question on a formula
User 23/07/2018 - 02:00
do you see the doc preview?
Excelchat Expert 23/07/2018 - 02:00
Yes, Got it
Excelchat Expert 23/07/2018 - 02:01
Yes, checking on it now
User 23/07/2018 - 02:01
awesome
User 23/07/2018 - 02:01
thanks
Excelchat Expert 23/07/2018 - 02:01
You're welcome
Excelchat Expert 23/07/2018 - 02:03
By the way, I will create the formula at your E1 as "yes" if all are yes and "no" if there's any "no" or blank value in any place of the ranges, right?
User 23/07/2018 - 02:03
yes correct
Excelchat Expert 23/07/2018 - 02:03
Thanks for the confirmation
User 23/07/2018 - 02:03
:)
Excelchat Expert 23/07/2018 - 02:03
User 23/07/2018 - 02:03
sure
User 23/07/2018 - 02:07
you there? just checking as my page refreshed
Excelchat Expert 23/07/2018 - 02:07
Yes
User 23/07/2018 - 02:08
ahh good thing
Excelchat Expert 23/07/2018 - 02:08
Please give me more minutes to create the formula for you
Excelchat Expert 23/07/2018 - 02:08
Thank you :)
User 23/07/2018 - 02:08
sure no worries
Excelchat Expert 23/07/2018 - 02:16
Hi there,
User 23/07/2018 - 02:16
hi
Excelchat Expert 23/07/2018 - 02:17
A bit more time for testing
User 23/07/2018 - 02:17
will the session be cut off in 3 mins?
Excelchat Expert 23/07/2018 - 02:17
Please bear with me more time, we can extend 'till done
User 23/07/2018 - 02:17
oh perfect
User 23/07/2018 - 02:17
ah there
Excelchat Expert 23/07/2018 - 02:17
Thanks :)
User 23/07/2018 - 02:17
so the free exstension
User 23/07/2018 - 02:17
*saw
Excelchat Expert 23/07/2018 - 02:17
Yes, don't worry
User 23/07/2018 - 02:18
thank you
Excelchat Expert 23/07/2018 - 02:18
You're welcome
Excelchat Expert 23/07/2018 - 02:34
=if(or(countif(B6:B16,"No")>0,countif(B6:B16,"")>0,countif(B21:B31,"No")>0,countif(B21:B31,"")>0,countif(B34:B38,"No")>0,countif(B34:B38,"")>0,countif(B41:B44,"No")>0,countif(B41:B44,"")>0,countif(B47:B58,"No")>0,countif(B47:B58,"")>0),"No","Yes")
Excelchat Expert 23/07/2018 - 02:34
Finally, the formula above had been created
User 23/07/2018 - 02:34
perfect
Excelchat Expert 23/07/2018 - 02:34
Thank you
User 23/07/2018 - 02:34
thank you
Excelchat Expert 23/07/2018 - 02:34
By the way, you can put some data for testing
User 23/07/2018 - 02:34
this will be for all ranges I noted right?
Excelchat Expert 23/07/2018 - 02:35
Yes
Excelchat Expert 23/07/2018 - 02:35
The ranges mentioned above
User 23/07/2018 - 02:35
great
Excelchat Expert 23/07/2018 - 02:35
Thank you
User 23/07/2018 - 02:35
thank you so much for your help
User 23/07/2018 - 02:35
i think it was quite hard
User 23/07/2018 - 02:35
so really thank you
User 23/07/2018 - 02:35
:)
Excelchat Expert 23/07/2018 - 02:35
No, it's simple
Excelchat Expert 23/07/2018 - 02:36
just need the repitions of the formula use by the logical thinking of yes or no
User 23/07/2018 - 02:36
just tried it
User 23/07/2018 - 02:36
works like a charm
Excelchat Expert 23/07/2018 - 02:36
So, first, we've checked the existence of "no" and blank data on the ranges by using COUNTIF formula
Excelchat Expert 23/07/2018 - 02:37
Thank you :)
Excelchat Expert 23/07/2018 - 02:37
Any more concern regarding the formula created?
User 23/07/2018 - 02:37
No I'm good
User 23/07/2018 - 02:37
I will just review your formula
User 23/07/2018 - 02:37
for future use
User 23/07/2018 - 02:37
thank you!
Excelchat Expert 23/07/2018 - 02:38
Oh, I love to hear your feedback with us.
Excelchat Expert 23/07/2018 - 02:38
Thank you too :)
User 23/07/2018 - 02:38
:)
Excelchat Expert 23/07/2018 - 02:38
For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.
User 23/07/2018 - 02:38
Will sure do
User 23/07/2018 - 02:38
bye for now
Excelchat Expert 23/07/2018 - 02:38
Thank you for coming at Got It Pro-Excel!
Excelchat Expert 23/07/2018 - 02:38
User 23/07/2018 - 02:38
you too
Excelchat Expert 23/07/2018 - 02:38
Cheers!!!

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.