software

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: www.excelforum.com/member.php...oamp;userid=31180
View this thread: www.excelforum.com/showthread...hreadid=508424Hi

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

, but because you want logical values to be returned, use better
=OR(B11=C11,B11=D11)
=AND(B11=C11,B11gt;D11)Arvi Laanemetsquot;mikebisphamquot; gt;
wrote in message
...
gt;
gt; Hi,
gt;
gt; I'm a student taking philosophical thinking, which includes using truth
gt; tables of the functions AND, OR, IF, NOT.
gt;
gt; It isn't part of he course, but I've been playing around with excel
gt; logical functions, and have all working except the 'material condition'
gt; if. Rather, I have got it working, but only by doing a 2 stage
gt; calculation along the lines of:
gt;
gt; 1 =IF(B11=C11,TRUE)
gt; 2 =OR(C11,D11)
gt;
gt; Can anyone tell me; a) is there a simpler way to do this, and/or b) how
gt; does one go about nesting these so that it can be done in one go?
gt;
gt; I'd be very grateful for any steers at all,
gt;
gt; Mike (UK)
gt;
gt;
gt; --
gt; mikebispham
gt; ------------------------------------------------------------------------
gt; mikebispham's Profile:
www.excelforum.com/member.php...oamp;userid=31180
gt; View this thread: www.excelforum.com/showthread...hreadid=508424
gt;

Hi Arvi and thanks,

Is there no way to do this in a single move - just testing two cells
and returning true/false to a third?

Mike--
mikebispham
------------------------------------------------------------------------
mikebispham's Profile: www.excelforum.com/member.php...oamp;userid=31180
View this thread: www.excelforum.com/showthread...hreadid=508424
quot;mikebisphamquot; gt;
wrote in message
...
gt;
gt; Hi Arvi and thanks,
gt;
gt; Is there no way to do this in a single move - just testing two cells
gt; and returning true/false to a third?

Doh ???

There were simply 2 different examples - one with AND used, and other with
OR - you didn't give any details what you actually needed. You use either
one or another, or create your own.

And a formula can't return something elsewhere - you must have the formula
in cell, where you want it's result to be displayed.Arvi Laanemetsgt;
gt; Mike
gt;
gt;
gt; --
gt; mikebispham
gt; ------------------------------------------------------------------------
gt; mikebispham's Profile:
www.excelforum.com/member.php...oamp;userid=31180
gt; View this thread: www.excelforum.com/showthread...hreadid=508424
gt;

Sorry to be so dim Arvi - I did say I was a beginner

What I mean here is that both the examples you give employ data from 3
different cells (B, C, and D).

What I want is to take a value TRUE/FALSE from, say, A1 and B1, and
have TRUE/FALSE displayed in C1.

The formula will, as you say, reside in C1

Is that possible?

If I can stretch your patience yet further, a similar formular for the
bi-conditional would also be great!

Thanks so much, I really am very grateful,

Mike--
mikebispham
------------------------------------------------------------------------
mikebispham's Profile: www.excelforum.com/member.php...oamp;userid=31180
View this thread: www.excelforum.com/showthread...hreadid=508424Hiquot;mikebisphamquot; gt;
wrote in message
...
gt;
gt; Sorry to be so dim Arvi - I did say I was a beginner
gt;
gt; What I mean here is that both the examples you give employ data from 3
gt; different cells (B, C, and D).
gt;
gt; What I want is to take a value TRUE/FALSE from, say, A1 and B1, and
gt; have TRUE/FALSE displayed in C1.
gt;
gt; The formula will, as you say, reside in C1Exactly!gt;
gt; Is that possible?
gt;
gt; If I can stretch your patience yet further, a similar formular for the
gt; bi-conditional would also be great!Here I did lost you again! More details, please!
Asking questions here, you get answers faster, when you:
1. describe, what you have initially and where (like 'I have values in cells
A2 and B2');
2. explain, what do you want get (like 'I want TRUE returned whenevwer both
values are equal and not empty').
(and don't use any termins which can interpreted differently by others -
p.e. I have no clue how to desipher this bi-conditional formula)Arvi Laanemets

Hi Arvi

The result I'm looking for (in the first instance) is the truth-table
for what is known in philosophy as the 'material condition':

TRUETRUETRUE
TRUEFALSEFALSE
FALSETRUETRUE
FALSEFALSETRUE

The third column (C) results from the combination of the first two, and
is ideally where the formula should reside. Its symbolised (in
philosophy) by A(arrow) B

Your quot;=OR(B11=C11,B11=A11)quot; works when the first column is B, the A
left blank and the results and formular in D

Your formular quot;=IF(OR(B11=C11,B11=D11),TRUE,FALSE)quot; works if D is left
blank and the formular placed in E... (or elsewhere)

I can't make the other two produce the right result. I'd prefer a
tidier solution where the formular residing in C tests A and B.

_______

The bi-conditional, written A(arrow pointing both ways)B produces the
following truth-table:

TRUETRUETRUE
TRUEFALSEFALSE
FALSETRUEFALSE
FALSEFALSETRUE

It means 'if and only if' (sometimes written iff). As you can see it
just wants to know if both A and B are the same.

I do hope that helps, and I'm sorry I don't know the lingo. As I say
I'm a philosophy student, and I'm using the terms I've been taught for
purposes of 'logical thinking'. We're supposed to apply these tests to
the components or arguments written in english, in order to discover if
they are 'sound' and 'valid'.

Again, thanks so very much for your help this far!

Mike--
mikebispham
------------------------------------------------------------------------
mikebispham's Profile: www.excelforum.com/member.php...oamp;userid=31180
View this thread: www.excelforum.com/showthread...hreadid=508424Hi

Into C1 enter
=OR(A1=B1,B1)
and copy down?

At least it returns wanted result for your example data. To get a true
answer, you have to ask better. This particular formula is an answer to a
task:
quot;Find the formula, which returns TRUE, whenever both entries in column A and
B are same (TRUE OR FALSE), or when the entry in column B is TRUEquot;. As you
easily can see, a task set properly often contains an answer.

Arvi Laanemetsquot;mikebisphamquot; gt;
wrote in message
...
gt;
gt; Hi Arvi
gt;
gt; The result I'm looking for (in the first instance) is the truth-table
gt; for what is known in philosophy as the 'material condition':
gt;
gt; TRUE TRUE TRUE
gt; TRUE FALSE FALSE
gt; FALSE TRUE TRUE
gt; FALSE FALSE TRUE
gt;
gt; The third column (C) results from the combination of the first two, and
gt; is ideally where the formula should reside. Its symbolised (in
gt; philosophy) by A(arrow) B
gt;
gt; Your quot;=OR(B11=C11,B11=A11)quot; works when the first column is B, the A
gt; left blank and the results and formular in D
gt;
gt; Your formular quot;=IF(OR(B11=C11,B11=D11),TRUE,FALSE)quot; works if D is left
gt; blank and the formular placed in E... (or elsewhere)
gt;
gt; I can't make the other two produce the right result. I'd prefer a
gt; tidier solution where the formular residing in C tests A and B.
gt;
gt; _______
gt;
gt; The bi-conditional, written A(arrow pointing both ways)B produces the
gt; following truth-table:
gt;
gt; TRUE TRUE TRUE
gt; TRUE FALSE FALSE
gt; FALSE TRUE FALSE
gt; FALSE FALSE TRUE
gt;
gt; It means 'if and only if' (sometimes written iff). As you can see it
gt; just wants to know if both A and B are the same.
gt;
gt; I do hope that helps, and I'm sorry I don't know the lingo. As I say
gt; I'm a philosophy student, and I'm using the terms I've been taught for
gt; purposes of 'logical thinking'. We're supposed to apply these tests to
gt; the components or arguments written in english, in order to discover if
gt; they are 'sound' and 'valid'.
gt;
gt; Again, thanks so very much for your help this far!
gt;
gt; Mike
gt;
gt;
gt; --
gt; mikebispham
gt; ------------------------------------------------------------------------
gt; mikebispham's Profile:
www.excelforum.com/member.php...oamp;userid=31180
gt; View this thread: www.excelforum.com/showthread...hreadid=508424
gt;
As a side note to the op, I believe your table is asking quot;does x imply y ?quot;
Unfortunately, Excel's worksheet functions do not have an quot;Implyquot; function.
However, there is one in Excel' vba. Arvi's example is better, but just for
reference...

Function Implies(x, y) As Boolean
Implies = x Imp y
End Function

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Arvi Laanemetsquot; gt; wrote in message
...
gt; Hi
gt;
gt; Into C1 enter
gt; =OR(A1=B1,B1)
gt; and copy down?
gt;
gt; At least it returns wanted result for your example data. To get a true
gt; answer, you have to ask better. This particular formula is an answer to a
gt; task:
gt; quot;Find the formula, which returns TRUE, whenever both entries in column A
gt; and
gt; B are same (TRUE OR FALSE), or when the entry in column B is TRUEquot;. As you
gt; easily can see, a task set properly often contains an answer.
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;mikebisphamquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; Hi Arvi
gt;gt;
gt;gt; The result I'm looking for (in the first instance) is the truth-table
gt;gt; for what is known in philosophy as the 'material condition':
gt;gt;
gt;gt; TRUE TRUE TRUE
gt;gt; TRUE FALSE FALSE
gt;gt; FALSE TRUE TRUE
gt;gt; FALSE FALSE TRUE
gt;gt;
gt;gt; The third column (C) results from the combination of the first two, and
gt;gt; is ideally where the formula should reside. Its symbolised (in
gt;gt; philosophy) by A(arrow) B
gt;gt;
gt;gt; Your quot;=OR(B11=C11,B11=A11)quot; works when the first column is B, the A
gt;gt; left blank and the results and formular in D
gt;gt;
gt;gt; Your formular quot;=IF(OR(B11=C11,B11=D11),TRUE,FALSE)quot; works if D is left
gt;gt; blank and the formular placed in E... (or elsewhere)
gt;gt;
gt;gt; I can't make the other two produce the right result. I'd prefer a
gt;gt; tidier solution where the formular residing in C tests A and B.
gt;gt;
gt;gt; _______
gt;gt;
gt;gt; The bi-conditional, written A(arrow pointing both ways)B produces the
gt;gt; following truth-table:
gt;gt;
gt;gt; TRUE TRUE TRUE
gt;gt; TRUE FALSE FALSE
gt;gt; FALSE TRUE FALSE
gt;gt; FALSE FALSE TRUE
gt;gt;
gt;gt; It means 'if and only if' (sometimes written iff). As you can see it
gt;gt; just wants to know if both A and B are the same.
gt;gt;
gt;gt; I do hope that helps, and I'm sorry I don't know the lingo. As I say
gt;gt; I'm a philosophy student, and I'm using the terms I've been taught for
gt;gt; purposes of 'logical thinking'. We're supposed to apply these tests to
gt;gt; the components or arguments written in english, in order to discover if
gt;gt; they are 'sound' and 'valid'.
gt;gt;
gt;gt; Again, thanks so very much for your help this far!
gt;gt;
gt;gt; Mike
gt;gt;
gt;gt;
gt;gt; --
gt;gt; mikebispham
gt;gt; ------------------------------------------------------------------------
gt;gt; mikebispham's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31180
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=508424
gt;gt;
gt;
gt;

gt;gt; TRUE TRUE TRUE
gt;gt; TRUE FALSE FALSE
gt;gt; FALSE TRUE TRUE
gt;gt; FALSE FALSE TRUE

As a side note, other definitions of A Implies B (A -gt;B) are
=OR(NOT(A1),B1)
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Arvi Laanemetsquot; gt; wrote in message
...
gt; Hi
gt;
gt; Into C1 enter
gt; =OR(A1=B1,B1)
gt; and copy down?
gt;
gt; At least it returns wanted result for your example data. To get a true
gt; answer, you have to ask better. This particular formula is an answer to a
gt; task:
gt; quot;Find the formula, which returns TRUE, whenever both entries in column A
gt; and
gt; B are same (TRUE OR FALSE), or when the entry in column B is TRUEquot;. As you
gt; easily can see, a task set properly often contains an answer.
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;mikebisphamquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; Hi Arvi
gt;gt;
gt;gt; The result I'm looking for (in the first instance) is the truth-table
gt;gt; for what is known in philosophy as the 'material condition':
gt;gt;
gt;gt; TRUE TRUE TRUE
gt;gt; TRUE FALSE FALSE
gt;gt; FALSE TRUE TRUE
gt;gt; FALSE FALSE TRUE
gt;gt;
gt;gt; The third column (C) results from the combination of the first two, and
gt;gt; is ideally where the formula should reside. Its symbolised (in
gt;gt; philosophy) by A(arrow) B
gt;gt;
gt;gt; Your quot;=OR(B11=C11,B11=A11)quot; works when the first column is B, the A
gt;gt; left blank and the results and formular in D
gt;gt;
gt;gt; Your formular quot;=IF(OR(B11=C11,B11=D11),TRUE,FALSE)quot; works if D is left
gt;gt; blank and the formular placed in E... (or elsewhere)
gt;gt;
gt;gt; I can't make the other two produce the right result. I'd prefer a
gt;gt; tidier solution where the formular residing in C tests A and B.
gt;gt;
gt;gt; _______
gt;gt;
gt;gt; The bi-conditional, written A(arrow pointing both ways)B produces the
gt;gt; following truth-table:
gt;gt;
gt;gt; TRUE TRUE TRUE
gt;gt; TRUE FALSE FALSE
gt;gt; FALSE TRUE FALSE
gt;gt; FALSE FALSE TRUE
gt;gt;
gt;gt; It means 'if and only if' (sometimes written iff). As you can see it
gt;gt; just wants to know if both A and B are the same.
gt;gt;
gt;gt; I do hope that helps, and I'm sorry I don't know the lingo. As I say
gt;gt; I'm a philosophy student, and I'm using the terms I've been taught for
gt;gt; purposes of 'logical thinking'. We're supposed to apply these tests to
gt;gt; the components or arguments written in english, in order to discover if
gt;gt; they are 'sound' and 'valid'.
gt;gt;
gt;gt; Again, thanks so very much for your help this far!
gt;gt;
gt;gt; Mike
gt;gt;
gt;gt;
gt;gt; --
gt;gt; mikebispham
gt;gt; ------------------------------------------------------------------------
gt;gt; mikebispham's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31180
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=508424
gt;gt;
gt;
gt;