MICROSOFT EXCEL FUNCTIONS- LOGICAL

LOGICAL FUNCTIONS

 

LOGICAL FUNCTIONS group comprise of the functions which help us to make logical decisions.

These functions are used to make a decision in Excel which make them very important to be learnt if you want to be proficient in Excel.

Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.

LOGICAL FUNCTIONS

EXCEL FUNCTIONS-XOR

INTRODUCTION Life is full of logical conditions. We wake up and we have two choices. Get out of the bed …
Read More

EXCEL FUNCTIONS-TRUE

INTRODUCTION A special situation may arise in EXCEL while creating any condition or function or formula, when we need to …
Read More

EXCEL FUNCTIONS-OR

INTRODUCTION OR function comes under the LOGICAL FUNCTIONS category in Excel. OR function is very important and is going to …
Read More

EXCEL FUNCTIONS-NOT

INTRODUCTION It behaves like BINARY NOT. NOT is simply the reverse of a binary value which means TRUE NOT=FALSE AND …
Read More

EXCEL FUNCTIONS-IFERROR

INTRODUCTION IFERROR function comes under the LOGICAL FUNCTIONS category in Excel. IFERROR is again a very useful function in excel …
Read More

EXCEL FUNCTIONS-IFS

INTRODUCTION IFS function comes under the LOGICAL FUNCTIONS category in Excel. IFS function is very important and is going to …
Read More

EXCEL FUNCTIONS-IF

Table of Contents INTRODUCTION PURPOSE OF IF IN EXCEL PREREQUISITES TO LEARN IF SYNTAX: IF FUNCTION EXAMPLE:IF FUNCTION IN EXCEL …
Read More

EXCEL FUNCTIONS-FALSE

INTRODUCTION A special situation may arise in EXCEL while creating any condition or function or formula, when we need to …
Read More

EXCEL FUNCTIONS-AND

Table of Contents INTRODUCTION PURPOSE OF AND IN EXCEL PREREQUISITES TO LEARN AND SYNTAX: AND FUNCTION EXAMPLE:AND FUNCTION IN EXCEL …
Read More