Pages

AND Function | And Function in Excel | Microsoft Office training

AND Function | And Function in Excel | Microsoft Office training

Today is our next Function by the name of AND Function. This function is use to show “TRUE” if all of the condition are TRUE and it returns “FALSE” if any of the condition are FALSE. As we will type this Function, we will see two condition and after condition you will see (…..) which means that you can type up to 30 conditions in And Function. 

Condition:-

Condition is something that you want to test that can either be “TRUE” and I can be “FALSE”.
Now let’s come to our topic that how we can use it. To learn it, please follow the steps which are given below.

First Method:- 

1) Start Microsoft Excel 2007.
2) Now type "50" and "Excel" in Excel worksheet as given below.

 3) Now type this function (=AND(E4>30,E4<70)) at the front of “50” as given below.


4) Press Enter, after press Enter, you will see “TRUE” because the mean of our function is “50 is greater than 30 and less than 70” so it’s true.

2ND Method:-

1) Now we are going to work on our next method which is our “Excel” word. Which one we have typed on our First Method. 
2) Now type this function (=AND(E5="PowerPoint")) at the front of “Excel” word as shown below.


 3) Press Enter, after Enter, You will see “FALSE” because we typed “E5 cell is equal to PowerPoint” and in real it’s not equal to PowerPoint so therefore it’s become FALSE and If we type this function (=AND(E5=”Excel”)) so it will become “TRUE”. 

3RD METHOD:-

1) Now we are going to use our function on “two condition”. Use this function (=AND(E4>40,E5="Excel")) anywhere you want to type. After type, press Enter, now you will see “TRUE” because “E4 cell is greater than 40 and E5 cell is equal to Excel”. So therefore our function becomes “TRUE”.

Our “AND Function” become End and if you have any problem so feel free and type your message, I will reply as soon as possible



0 comments:

Post a Comment