Thread: place an "x" in D2 if E2-I2 are empty of text??
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default place an "x" in D2 if E2-I2 are empty of text??
Hi,

Not quite sure if you want the x to appear if the other columns are all full
or all empty.

Try

=IF(COUNTA(E2:I2)=5,"x","")

or

=IF(COUNTA(E2:I2)=5,"","x")

Dave

url:http://www.ureader.com/msg/104241977.aspx
Reply With QuoteReply With Quote