I have a number of rows where the cell entries can be wither y, n or #N/A.

I want to create a final cell which looks at the data in the row. If there
is a Y in any of the cells, the final cell needs to be a "y". If there is not
a "y" in any of the cells, the final cell needs to be "n"

I've tried using an "if" formula. THis works against a single cell but can't
get it to work using a range of cells.

=if(a1:e1)="y", "y", "n"

Help appreciated.

Rob

Try this:

=IF(COUNTIF(A1:E1,"y")0,"y","n")

HTH,
Elkar


"reesrob" wrote:

I have a number of rows where the cell entries can be wither y, n or #N/A.

I want to create a final cell which looks at the data in the row. If there
is a Y in any of the cells, the final cell needs to be a "y". If there is not
a "y" in any of the cells, the final cell needs to be "n"

I've tried using an "if" formula. THis works against a single cell but can't
get it to work using a range of cells.

=if(a1:e1)="y", "y", "n"

Help appreciated.

Rob