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.

Have you tried the ISBLANK function?

--

HTH

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


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

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.

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.

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.

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.