[AccessD] Excel Question

I don't think I saw a reply to this question, so I'll pass this on. I
don't know exactly what you are trying to accomplish, but I used the
following code to test column A for Odd or Even. If it is blank it
returns "BLANK", but you could always have it do nothing ("").
 
 
=IF(ISBLANK(A3),"BLANK",IF(MOD(A3,2)=0,"EVEN","ODD"))

John W Clark

>>> pcs at azizaz.com 11/18/03 12:23AM >>>
Hi,
anyone with a quick answer to this one:

Excel appears to treat blank cell as zero

I've created a function that tests the value in a cell (say A1) using
Select
Case and delivers a value in another cell (say B1) depending on value
in
cell.

The function tests on values 0,1,2,3,4,5,6,7,8,9 and responds with a
message
if any other value is entered.

So far so good!

Now, the annoying part is that a blank value - null - is treated as
ZERO by
the function.


How do I turn this off - so that a the value of a blank cell is treated
as
null ???

Regards


Borge,


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com