Try one of these:
normally entered:
=IF(OR(C1D1,C2D1,C3D1,C4D1),G1,"")
array entered with the key combo of CTRL,SHIFT,ENTER:
=IF(OR(C1:C4D1),G1,"")
Biff
"Brian" wrote in message
...
I am having trouble with "and" , "or" in my formulas.
If I want one of c1:c4 to be true is this the formula to use
=if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither
one
of these formulas seems to work. In other words, I am trying to write a
shorter formula for the following:
=if(c1d1 or c2d1 or c3d1 or c4d1, G1,"")
Thanks for help with this simple formula.
|