Re: IF statements

I use a bit table to decide if a cell contains a value or is empty.
The bit table is set to all zeros as an integer 2 or 4 zeroing.
Frnm the coordinates of the cell I easily form a byte index and a bit
number.
As the table is filled I set the cell bit.
On processing I can check the bit.

This is the heart of survey processing of truth values to count
responses where the cell might contain a quantity.

.

Relevant Pages

  • Re: Is this possible ?
    ... Column A is actually empty (there is no formula ... solution and I have success. ... >formula that makes the cell appear emtpy under certain ... this appears to put zeros in every row of columns 3 ...
    (microsoft.public.excel.programming)
  • RE: Format cells to make zeros not appear,or be invisible on screen &p
    ... Does anyone know how to format a cell so that it looks empty when a zero is ... want to extend the format so that zeros appear as blanks (or rather, ...
    (microsoft.public.excel.misc)
  • Re: IF statements
    ... variable 'result' exists in a given cell - as I think Gus suggests. ... However, his code looks suitable only for Fortran 90, whereas I'm ... If the cell remains that number, then its value does "not exist". ... This is the heart of survey processing of truth values to count ...
    (comp.lang.fortran)
  • Re: If Function and empty cells
    ... I don't want to change the nothing values to zeros in my H ... I would like the cell to appear empty. ... > ANB ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Error Checking Code, Excel 2000 & 2003
    ... Sub ErrorCheckTEST() ... Dim cell as Range, cell1 as Range ... msg= "ERROR Description is empty" ... MsgBox "ERROR Description is empty" ...
    (microsoft.public.excel.programming)