ExcelBanter - IF an array..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF an array.. (https://www.excelbanter.com/excel-worksheet-functions/191378-if-array.html)

Michael

IF an array..

I am using the following formula:
=if( B2..Z2="n/a","Yes","No")
in attempt retreive a "Yes" if any within the data set has a "n/a".
The formula only retruns a"Yes" if the B2 cell is "n/a" - and otherwise
returns "No" when "n/a" exists within the group.

What is wrong?

Gary''s Student

IF an array..

=IF(COUNTIF(B2:Z2,"n/a")0,"Yes","No")

--
Gary''s Student - gsnu200792

All times are GMT +1. The time now is 08:41 AM.