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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Have you tried the ISBLANK function?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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.
 
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?
 
Back
Top