Excel 2013 - using Boolean logical functions

0 votes

click here for the image of my excel worksheet What is the formula for cell K3 (p=>q) => (p=>~q) . My goal is False, True, True, True. But I don't know the formula for it in excel. I tried this formula =or(not(OR(NOT(B3);C3);OR(NOT(B3);NOT(C3))) , but it said "you,ve entered too many arguments for this function.

NOTE :

Please only use AND, OR, and NOT functions.

p=>q is equivalent to ~pvq

p<=>q is equivalent to (p=>q)^(q=>p) is equivalent to (~pvq)^(~qvp)

~ = negation

=> = conditional "if-then"

Oct 7, 2022 in Others by Kithuzzz
• 38,010 points
331 views

1 answer to this question.

0 votes

If p is stored in A1 and q is in A2 then the formula in A3 will be:

=NOT(AND(A1,A2))
answered Oct 7, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
366 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,288 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
480 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
731 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
876 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,090 points
813 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,090 points
4,063 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,789 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
5,954 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
484 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP