Formula to return Y if cell has data and N if cell has no data

[stpeter]

Hello,
I need a formula that refers to a cell, and will return Y if there is data (a mix of letters or numbers) and N if the cell has not data (is empty).

In case I need it for future, could I also have a separate formula, to return blank for blank cells.

I am using Excel 2007.
Thank you,
SP

[nigelbloomy]

Is this something you can use?

Please Login or Register  to view this content.

Change the "N" to "" to get a blank instead for blank cells.

[bhenlee]

For your future reference:

=IF(ISBLANK(cell),"")

or

=IF(cell="","","other condition")

[stpeter]

Thank you both for your response.
I ran the formula and saw that each cell returned a Y as the referring cells have a 0 (zero), since it based from another formula.
So, I guess I will need this formula to be something that will return Y, if there is a string? (text and numbers), and N if it is blank or only 0 (zero).
I should have noted this in my original request, my apologies.

[bebo021999]

In comparison with 0, text/string or number that greater than 0 is greater than 0

So try this:

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

[stpeter]

Thank you Quang!
Works very well.