TRUE/FALSE depending on values in a column

[MSChe]

Hi!

I'm very pleased to present you my simple problematic
So I have 8 cells containing either TRUE or FALSE. The ninth cell should report the following content based on following conditions:

if one of those cells A2 >H2 contains "TRUE", then I2 should contain FALSE
if none of those cells contains "TRUE", then I2 should contain TRUE

I thank you veryyyy much in advance for your help.

Have a nice day

MS

[AliGW]

Yes, easy:

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J
1	.ch	.fr	.de	.it	.com	.co.uk	.net	.org	.other
2	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE		FALSE

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	J
2	=COUNTIF(A2:I2,TRUE)=0

Sheet: Sheet1

[MSChe]

very easy!

Ali, you saved my day

Thanks a lot!!

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

[AliGW]

Please take note of Glenn's post above.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.