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...
