First Post: If function

[Liz G]

Hi,

This is the first time I am posting to this newsgroup and if it is not the
right place for my question, please point me to the correct newsgroup.

I am trying to form an 'If' function to say: 'If a cell is not empty, enter
a 1, otherwise enter a 0'. Does anyone know if there is a way to do this?

Thanks,
Liz

 

[Paul B]

Liz, here is one way,
=IF(ISBLANK(A1),0,1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[JE McGimpsey]

Since boolean (TRUE/FALSE) values are coerced to 1/0 respectively by
math operations (such as negation, -), one way:

= --(A1<>"")

 

[BenjieLop]

=If(Cell_number<>"",1,0)

OR

=If(Cell_number="",0,1)


<< Hi,

This is the first time I am posting to this newsgroup and if it is no
the
right place for my question, please point me to the correct newsgroup.

I am trying to form an 'If' function to say: 'If a cell is not empty
enter
a 1, otherwise enter a 0'. Does anyone know if there is a way to d
this?

Thanks,
Liz >