Excel Logical and Information Functions

Logical & Information Functions

"Thanks you everyone for your response. Today we are going to discuss Excel's Logical & Information  functions. "

 

Before you start: Excel has only 2 logical statement TRUE and FALSE (this is different from if you type them as a text, means just put apostrophe before true or false). In excel True =1 and False =0.
So basic understand is that every logical condition will only return you either TRUE or FALSE, if not you would get the error as a output. If function can take advantage of any information formulas since if has the ability to show output based on condition/s :) 

 

Lets start the functions :)

• IF- Based on the logical test (True / False) allow user to show output. 

• AND - Returns TRUE if multiple condition are true. 

• OR- Returns TRUE if any argument is TRUE. 

• XOR - Returns TRUE, if 1 condition is true and 2 is false or vice versa. If both True and False it shows as false. If you take more then 2 arguments then results would be depends on number of conditions (either odd or Even then return True or False).

• TRUE - Logical value (if you simple put in 1st argument of if, your True part will be executed). 

• FALSE- Logical value (if you simple put in 1st argument of if, your False part will be executed).

• NOT - Reverse the logic of any logical test (Not(False) is same as True). 

• IFERROR - Error the handles and if error occurs in statement then it will show the next user defined output.  

• ISBLANK - Returns TRUE if the value is blank.

•  ISERR - Returns TRUE if the value is any error value except #N/A.

• ISNA - Returns TRUE if the value is the #N/A error value.

• ISERROR - Returns TRUE if the value is any error value.

• ISEVEN - Returns TRUE if the number is even.

• ISODD - Returns TRUE if the number is odd.

• ISLOGICAL - Returns TRUE if the value is a logical value.

• ISREF - Returns TRUE if the value is a reference.

• ISNUMBER - Returns TRUE if the value is a number.

• ISTEXT - Returns TRUE if the value is text.

• ISNONTEXT - Returns TRUE if the value is not text.

Here is the sample file you can use it to practice where I have created some of the samples..

                     Download workbook

Here is the YouTube video, where I have explained everything..

Please get in touch for any query help or suggestion..
Youtube
Facebook Page
Twitter
Email: lkthecool@gmail.com