simple formula

[Brian]

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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")

Thanks for help with this simple formula.

[Biff]

Try one of these:

normally entered:

=IF(OR(C1>D1,C2>D1,C3>D1,C4>D1),G1,"")

array entered with the key combo of CTRL,SHIFT,ENTER:

=IF(OR(C1:C4>D1),G1,"")

Biff

"Brian" <[email protected]> wrote in message
news:[email protected]...
>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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

[mangesh_yadav]

=IF(SUMPRODUCT(--(C1:C4>D1))>0,G1,"")

Mangesh

[paul]

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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

[Duke Carey]

Try

=if(or(c1:c4)>d1,g1,"")

but commit the formula by pressing Ctrl-Shift-Enter to make it an array
formula



"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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

[bj]

try
=if(or(C1>D1,C2>D1,C3>D1,C5>D1),G1,"")
or
=if(max(C1:C4)>D1,G1,"")

"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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

[bj]

This may be a second response but
try
=if(or(C1>D1,C2>D1,C3>D1,C4>D1),G1,"")
or
=if(max(C1:C4)>D1,G1,"")


"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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

[Greg Neill]

"Brian" <[email protected]> wrote in message
news:[email protected]...
>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(c1>d1 or c2>d1 or c3>d1 or c4>d1, G1,"")
>
> Thanks for help with this simple formula.

How about

=if (MAX(c1:c4)>d1,g1,"")