Thread: IF(ISBLANK question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
  
Posts: 275
Default 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?
Reply With QuoteReply With Quote