1

implication logical sheet

How can I use implication in Excel formulas? Just like other Excel logical functions for Boolean calcs? The same question for OpenOffice and Google sheets as well.

Improve this question
1
  • Please, edit and embed the image instead.
    – Hannu
    Commented Oct 2, 2020 at 16:22

3 Answers 3

Reset to default
1

=OR(NOT(x1), x2)
A -> B <=> ¬ A ∨ B

Improve this answer
0

Based on your provided truth-table, using True and False...

=NOT(AND(x1==True,x2==False))

What it does; AND() creates a "True" when (x1 is True) AND (x2 is False) both at the same time.
NOT() reverses this, so leaving "False" as result instead,
the AND() will leave a False in all other cases - reversed to True by NOT().

Should be the exact same regardless of which spreadsheet you use.

Improve this answer
2
  • I posted my solution. It is not a perfect but works. Thanks
    – Yurij
    Commented Oct 1, 2020 at 14:21
  • Read wiki about DNF & CNF in Boolean was useful for me
    – Yurij
    Commented Oct 1, 2020 at 16:31
0

my realization of logical implication in excel =IF(A2+B2=0;1; IF(AND(A2=0;B2=1);1; IF(AND(A2;B2);1;0)))" I use localized russian excel so ru version =ЕСЛИ(A2+B2=0;1;ЕСЛИ(И(A2=0;B2=1);1;ЕСЛИ(И(A2;B2);1;0)))

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .