software

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: www.excelforum.com/member.php...oamp;userid=25521
View this thread: www.excelforum.com/showthread...hreadid=499062Try this:
=IF(AND(OR(G7=G38,H7=G38,I7=G38),H38gt;10),quot;TRUEquot;,quot;F ALSEquot;)

quot;pyteliumquot; gt; wrote in
message news
gt;
gt; I want to print true if the number in cell g7 or the number in h7 or the
gt; number
gt; in I7 is equal to the number in g38 AND the number in h38 is greater
gt; than 10.
gt; There are 2 conditions to be fulfilled.
gt;
gt;
gt; --
gt; pytelium
gt; ------------------------------------------------------------------------
gt; pytelium's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25521
gt; View this thread: www.excelforum.com/showthread...hreadid=499062
gt;
=IF(H38gt;10,IF(OR(G7=G38,H7=G38,I7=G38),TRUE,FALSE) )
paul
remove nospam for email addy!
quot;pyteliumquot; wrote:

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


Thanks Guys,both work!--
pytelium
------------------------------------------------------------------------
pytelium's Profile: www.excelforum.com/member.php...oamp;userid=25521
View this thread: www.excelforum.com/showthread...hreadid=499062