If cell has a value return "Y" if the cell is blank return "N"

[CEM]

Part 1:
Two columns (A,B).
Column A either has cells with values (including 0) or they are blank.
I would like column B to return "Y" if the cells on the same row in column B has a value and "N" if it is blank.

I am currentyl using =IF(A1>0,"Y","N")

it returns "Y" for all cells including the blank cells.

Part 2:
Is there any way I can return a "Y" if the cell contains an interger (+ or -) and still return a "N" for blank cells?

Thank you- Daniel

[jeffreybrown]

Hi Daniel,

How about

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

N >> checks to see if A1 is a number

Len >> makes sure a value has been entered

[ben_hensel]

ISBLANK(A1) is a boolean function that returns TRUE if the cell (A1 in this case) has anything in it and FALSE if it's empty.

ISNUMBER(A1) is similar (a boolean that checks what's in a cell), but it looks for whether the cell contains a number.

Both are "information" type functions.

If you want to check whether a cell contains an integer, as opposed to a real number, then I'd suggest something like, IF(A1-INT(A1) > 0, 'what do if true', 'what do if false') ; but someone else might know a more elegant approach.

So ultimately:

Please Login or Register  to view this content.

That work???

[BarryTSL]

Try =IF(A1="","N","Y")

[CEM]

Jeff- success once again. Thank you - Daniel

[jeffreybrown]

You're very welcome Daniel…Thanks for the follow up and glad it worked for you.