conditional functions
 

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

conditional functions
 

Try this:
=IF(AND(OR(G7=G38,H7=G38,I7=G38),H3810),"TRUE","F ALSE")

"pytelium" wrote in
message ...

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

conditional functions
 

=IF(H3810,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

conditional functions
 

Thanks Guys,both work!


--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=499062