If Not blank - Formula for two cells

INMD13

New member
Joined
Mar 15, 2013
Messages
6
Reaction score
0
Points
0
Excel Version(s)
Mac Version 16.21.1
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.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
=IF(OR(A1<>"",B1<>""),1,0)

or

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