Excel Neophyte... need some help with a formula, please

[Prodetik]

I have a row of 'Yes'/'No' data (43 columns - N2:BD2) in an Excel spreadsheet... I have a column that precedes the first column of 'Yes'/'No' (M2) in which I'm needing an equation that if 1 or more of the data cells (N2:BD2) contain a 'Yes', I need the value of 'True' to populate into the M1 cell. If all of the cells (N2:BD2) contain 'No', I need the value of 'False' to populate into that cell.

Any assistance would be greatly appreciated, and thank you in advance for your time and attention.

Prodetik

[JohnTopley]

Try


=IF(COUNTIF(N2:BD2,"YES"),"True","False")

TRUE if any YES, otherwise false (does not check for ALL being NO)

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[oeldere]

try this one (untested)

=if(countif($N2:$BD2,"yes")>1,"yes","false")

[Prodetik]

shg - My apologies... I will review rules and ensure compliance for future posts.


JohnTopley - Thank You! ...your formula worked brilliantly.

[Tony Valko]

=IF(COUNTIF(N2:BD2,"YES"),"True","False")

Maybe like this...

=COUNTIF(N2:BD2,"YES")>0