=IF(OR(A1<>"",B1<>""),1,0)
or
=(OR(A1<>"",B1<>"") )+0
Hi All,
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(OR(A1<>"",B1<>""),1,0)
or
=(OR(A1<>"",B1<>"") )+0
Bookmarks