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

[Guest]

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.

 

[Bob Phillips]

Have you tried the ISBLANK function?

--

HTH

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

 

[Guest]

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.

 

[Dennis]

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?

 

[dfwddr]

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

 

[Showboat911]

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