How do I do and if and statement to tell me if 3 cells are blank ie if a1,B1 and C1 are blank then 'yes'
How do I do and if and statement to tell me if 3 cells are blank ie if a1,B1 and C1 are blank then 'yes'
if(and(a1="",b1="",c1=""),"yes","")
if(countif(a1:c1,"")=3,"yes","")
Formula:Please Login or Register to view this content.
Last edited by kev_; 02-19-2018 at 11:30 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
kev, OP shows 2010, concat, textjoin are not available to them
counta() is what I would go with, DEPENDING on if teh cells are really blank/empty/contain nothing. If they contain formulas that show "", that wont work either, OP will probably need to use COUNTIF() or SDUMPRODUCT()...
=COUNTIF(H16:L16,"")
=SUMPRODUCT(--(H16:L16=""))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks