XOR Function

XOR Function

XOR returns a logical exclusive OR of all arguments. For two logical statement, XOR returns TRUE if anyone statement is TRUE and return FALSE if both statements are TRUE. Buddy, we can remember it... Read more »
IFNA Function

IFNA Function

  VLOOKUP returns the #N/A error if it can’t find a value in a lookup table. The IFNA  function allows you to catch errors and return your own custom value when there... Read more »

OR Function

OR:  OR is the logical function to work with Logical values. We can use this logical function when we want to carry out more than one comparison in our formula or we want... Read more »
NOT Function

NOT Function

NOT:-  NOT returns opposite of given logical or Boolean value. When given TRUE, NOT returns FALSE. Why do we want to get such a ridiculous result? In certain cases, we might be... Read more »
IF Function

IF Function

IF Function in Excel IF is widely used function in excel. IF function in excel help us to make logical comparisons between value and what we expect. For comparison test with IF... Read more »