Excel Logical Statements True or False

In this tutorial I will be talking about the Foundation of Logical Statements that is true or false in Excel with the help of examples given below:

Question 1:

Full Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • Get Course Completion Certificate & Excel Mastery eBooks

In this table, we are having two columns, say salary and division. There are five records mention in the Division column. So now we have to figure out which division is getting a salary higher than $50,000

So to figure out, we will be applying a Logical statement that is true or false in Excel by following the steps given below:

1. Press = and select the Salary cell =B6

2. Write >50000 =B6>50000

3. Press Enter

4. Excel will calculate the answer

5. Lastly, double click on the corner cell to know the other answers in the table

Question 2:

In this table, we are having two columns, say salary and division. There are four different Divisions mentioned in the Division column. Now I want to know the total number of persons working in the RAD Division

So in order to find out the number of persons, we will be applying a Logical statement that is true or false in Excel by following the steps given below:

1. Press = and select the Salary cell =C6

2. Again press = and write rad by opening and closing Double Quotation (“) =C6=”rad”

Note – This is not case sensitive so you can write in capital or lower letter

3. Press Enter

4. Excel will calculate the answer

5. Lastly, double click on the corner cell to know the other answers in the table