Hi,

I have a problem with the logical test part of my IF statement. Here is a very simplified version of the issue which still highlights the problem:

Formula entered in Cell C1:

=IF((A1:A3)>0, "Y", "N")

What I want this formula to do is to return "Y" in cell C1 if any of the cells in the range contain a value and to return "N" otherwise. I must be doing something wrong as the function returns the true statement only when there is a value in cell A1 but returns a false statement if the other cells (A2 or A3) contain a value.

Could you please advise what's wrong with my specification of the range, or perhaps suggest a better way of achieving the same result.

Any advice is much appreciated and thanks in advance.

Anar