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 …
EXCEL FUNCTIONS-TRUE
INTRODUCTION A special situation may arise in EXCEL while creating any condition or function or formula, when we need to …
EXCEL FUNCTIONS-OR
INTRODUCTION OR function comes under the LOGICAL FUNCTIONS category in Excel. OR function is very important and is going to …
EXCEL FUNCTIONS-NOT
INTRODUCTION It behaves like BINARY NOT. NOT is simply the reverse of a binary value which means TRUE NOT=FALSE AND …
EXCEL FUNCTIONS-IFERROR
INTRODUCTION IFERROR function comes under the LOGICAL FUNCTIONS category in Excel. IFERROR is again a very useful function in excel …
EXCEL FUNCTIONS-IFS
INTRODUCTION IFS function comes under the LOGICAL FUNCTIONS category in Excel. IFS function is very important and is going to …
How to use IF Function in Excel- Step by step
Table of Contents INTRODUCTION What is the use of IF Function in Excel? Prerequisites to learn IF Function in Excel …
EXCEL FUNCTIONS-FALSE
INTRODUCTION A special situation may arise in EXCEL while creating any condition or function or formula, when we need to …
EXCEL FUNCTIONS-AND
Table of Contents INTRODUCTION PURPOSE OF AND IN EXCEL PREREQUISITES TO LEARN AND SYNTAX: AND FUNCTION EXAMPLE:AND FUNCTION IN EXCEL …