TB's Code Library
If it ain't tight, it ain't right!
Search
Thursday, October 03, 2013
Excel "IF~OR~AND" Formula
Excel Formula to check if B1 or C1 or D1 contain a value of "1" AND if the E1 = "1". If TRUE, then A1 = "1", otherwise, A1 = "0".
Place the following formula in cell A1:
=IF(AND(OR($B$1=1,$C$1=1,$D$1=1),$E$1=1),1,0)
Newer Post
Older Post
Home