Thread: How would I edit this formula to do what I want?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
  
Posts: 788
Default How would I edit this formula to do what I want?
Try this:

=IF(OR(ISBLANK(X4),ISBLANK(Y4)),"",IF(COUNT(X4,Y4) =2,IF(TODAY()Y4,"Yes",""),"No") )

"Danny Boy" wrote:

I'd like to modify this formula so that the NO Flag appears if a date is
missing in BOTH X4 and Y4. The current formula generates the NO flag, if a
date is missing in either X4 or Y4. Any suggestions?

=IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No")
Reply With QuoteReply With Quote