Previous Topic Next Topic

An if or contain query?

Closed
db123987 - Jun 1, 2010 at 10:24 AM
 seeBlack - Jun 1, 2010 at 05:32 PM
Hello,



could anyone help me,......if cells a to f contain YES then cell g reads as YES or NO.

i tried =IF(a1:f1=yes,"yes","no")

many thanks
Related:

3 responses

Answer 1 / 3
closeup22 Posts 8923 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,099
Jun 1, 2010 at 11:51 AM
Hi there,

Link below will definitely solve your issue with instructions,tutorials and examples using ''If'':

http://office.microsoft.com/en-us/excel/HP052091181033.aspx

Thanks
0
Answer 2 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 1, 2010 at 01:34 PM
use a countIF to see if you have 6 yes in the columns
0
Answer 3 / 3
seeBlack
Jun 1, 2010 at 05:32 PM
=IF(COUNTIF(A1:F1,"yes")>=1,"yes","no")
use above if ANY cell has a yes. IF ALL cells a thru f have yes then >=1 is changed to =7
0

Similar discussions

Hashtag query
pard1376 -
dwebb -

1 response
Invalid search query - returning all mail
lisa -
Ambucias -

1 response