If Not blank - Formula for two cells

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

Thanks!!!

Great! This worked perfectly thank you so much

NBVC said:

=IF(OR(A1<>"",B1<>""),1,0)

or

=(OR(A1<>"",B1<>"") )+0

Click to expand...