ExcelBanter - ISBLANK()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ISBLANK() (https://www.excelbanter.com/excel-worksheet-functions/148472-isblank.html)

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.

try

=NOT(ISBLANK(A1))

"kw_uh97" wrote:

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.

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" wrote:

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.

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

"Duke Carey" wrote:

try

=NOT(ISBLANK(A1))

"kw_uh97" wrote:

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.

You might try the cleaner:

=NOT(ISBLANK(A1))

HTH,
Paul

"kw_uh97" wrote in message
...
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" wrote:

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.

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)

"Duke Carey" wrote:

try

=NOT(ISBLANK(A1))

"kw_uh97" wrote:

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.

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)

"PCLIVE" wrote:

You might try the cleaner:

=NOT(ISBLANK(A1))

HTH,
Paul

"kw_uh97" wrote in message
...
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" wrote:

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.

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)

"Teethless mama" wrote in message
...
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)

"PCLIVE" wrote:

You might try the cleaner:

=NOT(ISBLANK(A1))

HTH,
Paul

"kw_uh97" wrote in message
...
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" wrote:

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.

"Peo Sjoblom" wrote...
....
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".