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
--
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?

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?

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?