Discussion Groups Home

A logical test in the If function for blank, i.e., If blank? in Excel Worksheet Functions

1/1/2006 10:41 AM PST

Question

I would like to use a logical test of If blank. It seems that I am able to
test for the value of zero, but not for blanks or an empty cell. I am
attempting to not select a cell if it has blanks or is empty, and do select
it if it has zero. In essence, I am selecting between plan and actual, and
the actual is to be selected when it has zero and when simultaneously the
plan has a quantity greater than zero.

Was this post helpful to you?

Top

Larry

1/1/2006 11:33 AM PST

Answer

egii, select a new worksheet. Leave A1 blank (empty). In column B1 enter
'=IF(A1="","BLANK",A1)'.
If you enter a character in A1 then the BLANK changes to the entered
character.
So to test for a blank cell the entry double quotes with no space between
them ("").
Hope this helps and have a Happy New Year.
--
Larry

"egii" wrote:

> I would like to use a logical test of If blank. It seems that I am able to
> test for the value of zero, but not for blanks or an empty cell. I am
> attempting to not select a cell if it has blanks or is empty, and do select
> it if it has zero. In essence, I am selecting between plan and actual, and
> the actual is to be selected when it has zero and when simultaneously the
> plan has a quantity greater than zero.

Was this post helpful to you?

Top

Dennis

2/27/2009 10:20 AM PST

I am having a simular problem. Even though the value may be blank, if the
cell contains a fomular, the test is true.

Any suggestion?

"Larry" wrote:

> egii, select a new worksheet. Leave A1 blank (empty). In column B1 enter
> '=IF(A1="","BLANK",A1)'.
> If you enter a character in A1 then the BLANK changes to the entered
> character.
> So to test for a blank cell the entry double quotes with no space between
> them ("").
> Hope this helps and have a Happy New Year.
> --
> Larry
>
>
> "egii" wrote:
>
> > I would like to use a logical test of If blank. It seems that I am able to
> > test for the value of zero, but not for blanks or an empty cell. I am
> > attempting to not select a cell if it has blanks or is empty, and do select
> > it if it has zero. In essence, I am selecting between plan and actual, and
> > the actual is to be selected when it has zero and when simultaneously the
> > plan has a quantity greater than zero.

Was this post helpful to you?

Top

dfwddr

4/29/2009 4:59 PM PST

Thanks for your help Larry.
I ended up with"=IF(A1="","",A1)"for a cleaner look.

"Larry" wrote:

> egii, select a new worksheet. Leave A1 blank (empty). In column B1 enter
> '=IF(A1="","BLANK",A1)'.
> If you enter a character in A1 then the BLANK changes to the entered
> character.
> So to test for a blank cell the entry double quotes with no space between
> them ("").
> Hope this helps and have a Happy New Year.
> --
> Larry
>
>
> "egii" wrote:
>
> > I would like to use a logical test of If blank. It seems that I am able to
> > test for the value of zero, but not for blanks or an empty cell. I am
> > attempting to not select a cell if it has blanks or is empty, and do select
> > it if it has zero. In essence, I am selecting between plan and actual, and
> > the actual is to be selected when it has zero and when simultaneously the
> > plan has a quantity greater than zero.

Was this post helpful to you?

Top

Bob Phillips

1/1/2006 11:35 AM PST

Have you tried the ISBLANK function?

--

HTH

RP
(remove nothere from the email address if mailing direct)

"egii" <egii@discussions.microsoft.com> wrote in message
news:5F2FC510-FAD8-48CD-ACC2-BB6C1DF3DC51@microsoft.com...
> I would like to use a logical test of If blank. It seems that I am able
to
> test for the value of zero, but not for blanks or an empty cell. I am
> attempting to not select a cell if it has blanks or is empty, and do
select
> it if it has zero. In essence, I am selecting between plan and actual,
and
> the actual is to be selected when it has zero and when simultaneously the
> plan has a quantity greater than zero.

Was this post helpful to you?

Top

Showboat911

9/16/2009 3:45 AM PST

I think the "value" would suit your purposes
IN D1 TRY
"=IF(VALUE(A1)<=0,"",C1-B1)"

"egii" wrote:

> I would like to use a logical test of If blank. It seems that I am able to
> test for the value of zero, but not for blanks or an empty cell. I am
> attempting to not select a cell if it has blanks or is empty, and do select
> it if it has zero. In essence, I am selecting between plan and actual, and
> the actual is to be selected when it has zero and when simultaneously the
> plan has a quantity greater than zero.

Was this post helpful to you?

Top

	Return to Microsoft Communities		Notify me of replies