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
Bookmarks