Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count on condition / Formula | Excel Worksheet Functions | |||
Can I set up a formula to lookup a value for a condition | Excel Discussion (Misc queries) | |||
Multiple Condition Formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Add condition to formula | Excel Worksheet Functions |