MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If / or


Posted by Joe C on September 27, 2001 6:42 AM

I have two columns with indicators in them.
How do I write in a cell an if statement that will put a 1 in another cell if on eo the 2 are not blank?
Any help is greatly appreciated.


Posted by Russell Hauf on September 27, 2001 7:06 AM

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

Hope this helps,

Russell

Posted by Aladin Akyurek on September 27, 2001 9:37 AM


=(COUNTBLANK(B1:C1)>0)+0

Aladin

===========

Posted by Aladin Akyurek on September 27, 2001 9:38 AM

Needs fixing...