ISBLANK()

[kw_uh97]

Hi, Everyone, I am not sure if I am double posting so I apologize before hand
if so.

This shoud be very easy, I am using the ISBLANK() function but I want the
results to be TRUE if there are values within the cell and if there are NOT
values in the cell return FALSE. So I would like it to return just the
opposite.

Thanks In Advance For your Assistance.

 

[Duke Carey]

try

=NOT(ISBLANK(A1))

 

[kw_uh97]

Was able to wrap a IF() function around the ISBLANK() to get what I wanted
with the results.

Here is the statement in case anyone needs the help.

=IF(ISBLANK(A1)=FALSE, TRUE, FALSE)

Sorry to bother Everyone.
Thanks

 

[kw_uh97]

Thanks Duke, much cleaner solution than mine. I'll use yours.

 

[PCLIVE]

You might try the cleaner:

=NOT(ISBLANK(A1))

HTH,
Paul

 

[Teethless mama]

You formula also returns "TRUE" when text is enter in A1. OP quote "I want the
results to be TRUE if there are values within the cell and if there are NOT
values in the cell return FALSE."

Here is the correction:

=ISNUMBER(A1)

 

[Teethless mama]

You formula also returns "TRUE" when text is enter in A1. OP quote "I want the
results to be TRUE if there are values within the cell and if there are NOT
values in the cell return FALSE."

Here is the correction:

=ISNUMBER(A1)

 

[Peo Sjoblom]

The word "values" does not necessarily mean numeric values, I interpret it
as Paul and Duke,
note that the OP said "the opposite of ISBLANK"


another way might be to use

=A1<>""


IF A1 could hold a formula that returned "" then ISBLANK won't work


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Harlan Grove]

another way might be to use

=A1<>""

IF A1 could hold a formula that returned "" then ISBLANK won't
work

....

Getting back to what the OP means by 'blank'.

FWIW, there's also

=COUNTA(A1)=1

or simply

=COUNTA(A1)

with number format [=1]"True";[=0]"False".