If Not blank - Formula for two cells
 

Hi I was wondering how I can write write the following formula. I want the formula to return a "1" if either cell A1 or B1 is NOT blank,otherwise retunr "0".

IT would look something like this

IF(NOT(ISBLANK(A1, B1)), 1, 0) <- This is not working for me.

If Not blank - Formula for two cells
 

Hi,

Am Fri, 15 Mar 2013 15:59:52 +0000 schrieb INMD13:

Hi I was wondering how I can write write the following formula. I want
the formula to return a "1" if either cell A1 or B1 is NOT
blank,otherwise retunr "0".

IT would look something like this

IF(NOT(ISBLANK(A1, B1)), 1, 0) <- This is not working for me.

try:
=IF(OR(LEN(A1)0,LEN(B1)0),1,0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2