IF(ISBLANK question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have this formula in cell P23 which almost works...

=IF(COUNTIF(P17:S19,P21)>0,"W","L")

can you suggest how to change this to show cell P23 as blank if Y6 is blank
but if Y6 is populated then carry out the formula?
 
=if(isblank(y6),"",if(countif(p17:s19,p21)>0,"W","L"))

I don't know how P23 factors into your question, as it is being used in the
COUNTIF range in your formula.

Dave
 
Anthony,

=IF(Y6="","",IF(COUNTIF(P17:S19,P21)>0,"W","L"))

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help please 1
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3
RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS 4
If or 3
if(and(isblank( formula help 2
Average IF? 1
Inserting "true" blanks with functions 5
IS BLANK checking 2 Cells 6

Back
Top