conditional functions

[pytelium]

I want to print true if the number in cell g7 or the number in h7 or the number
in I7 is equal to the number in g38 AND the number in h38 is greater than 10.
There are 2 conditions to be fulfilled.

[Barb Reinhardt]

Try this:
=IF(AND(OR(G7=G38,H7=G38,I7=G38),H38>10),"TRUE","FALSE")

"pytelium" <[email protected]> wrote in
message news:[email protected]...
>
> I want to print true if the number in cell g7 or the number in h7 or the
> number
> in I7 is equal to the number in g38 AND the number in h38 is greater
> than 10.
> There are 2 conditions to be fulfilled.
>
>
> --
> pytelium
> ------------------------------------------------------------------------
> pytelium's Profile:
> http://www.excelforum.com/member.php...o&userid=25521
> View this thread: http://www.excelforum.com/showthread...hreadid=499062
>

[paul]

=IF(H38>10,IF(OR(G7=G38,H7=G38,I7=G38),TRUE,FALSE))
paul
remove nospam for email addy!



"pytelium" wrote:

>
> I want to print true if the number in cell g7 or the number in h7 or the
> number
> in I7 is equal to the number in g38 AND the number in h38 is greater
> than 10.
> There are 2 conditions to be fulfilled.
>
>
> --
> pytelium
> ------------------------------------------------------------------------
> pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
> View this thread: http://www.excelforum.com/showthread...hreadid=499062
>
>

[pytelium]

Thanks Guys,both work!