and will return true if all arguements are true,or will return true if only
one argument is true
--
paul
remove nospam for email addy!



"Brian" wrote:

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.