Hi

=IF(OR(B11=C11,B11=D11),TRUE,FALSE)
=IF(AND(B11=C11,B11D11),TRUE,FALSE)

, but because you want logical values to be returned, use better
=OR(B11=C11,B11=D11)
=AND(B11=C11,B11D11)


Arvi Laanemets


"mikebispham"
wrote in message
...

Hi,

I'm a student taking philosophical thinking, which includes using truth
tables of the functions AND, OR, IF, NOT.

It isn't part of he course, but I've been playing around with excel
logical functions, and have all working except the 'material condition'
if. Rather, I have got it working, but only by doing a 2 stage
calculation along the lines of:

1 =IF(B11=C11,TRUE)
2 =OR(C11,D11)

Can anyone tell me; a) is there a simpler way to do this, and/or b) how
does one go about nesting these so that it can be done in one go?

I'd be very grateful for any steers at all,

Mike (UK)


--
mikebispham
------------------------------------------------------------------------
mikebispham's Profile:
http://www.excelforum.com/member.php...o&userid=31180
View this thread: http://www.excelforum.com/showthread...hreadid=508424