IF(ISBLANK question
 

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 question
 

=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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Anthony" wrote:

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 question
 

Anthony,

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

HTH,
Bernie
MS Excel MVP


"Anthony" wrote in message
...
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 question
 

Bernie thanks, that works just great

"Bernie Deitrick" wrote:

Anthony,

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

HTH,
Bernie
MS Excel MVP


"Anthony" wrote in message
...
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?