IFNA, XOR FUNCTIONS

IFNA( ):
I have given about the formula syntax and usage of the IFNA function in Microsoft Excel.

Description:
Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.

Syntax:
IFNA(value, value_if_na)
The IFNA function syntax has the following arguments.

• Value    Required. The argument that is checked for the #N/A error value.
• Value_if_na    Required. The value to return if the formula evaluates to the #N/A error value.

Remarks:

• If Value or Value_if_na is an empty cell, IFNA treats it as an empty string value ("").
• If Value is an array formula, IFNA returns an array of results for each cell in the range specified in value.

 
Q:
How to use IFNA function to correct the error message, when it’s possible?
Type the function as follows in the cell that you would like to get the result in:
=IFNA(VLOOKUP("MyCorp”, $A$2:$C$7,0),"Not in the table")
 
Note: When you use VLOOKUP function to look up for a value, if there is not matched that value, then VLOOKUP will reply error message(#N/A). So, I have used IFNA function to short out such this problems in the Match Testing table.
 
For more understanding, look at the screenshot please:

XOR( ):
I have given here about the formula syntax and usage of the XOR function in Microsoft Excel.
 
Description:
Returns a logical Exclusive Or of all arguments.
 
Syntax:
XOR(logical1, [logical2],…)
The XOR function syntax has the following arguments.

• Logical1, logical2,…    Logical 1 is required, subsequent logical values are optional. 1 to 254 conditions you want to test that can be either TRUE or FALSE, and can be logical values, arrays, or references.

Remarks:

• All the arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values. And an array or reference argument contains text or empty cells, those values are ignored.

 

• If the specified range contains no logical values, XOR returns the #VALUE! error value. And you can use an XOR array formula to see if a value occurs in an array. To enter an array formula, press Ctrl+Shift+Enter.

Q:
How to use XOR function to check the logical value is TRUE or FALSE?
Type the function as follows in the cell that you would like to get the result in:
=XOR(D3>0, D3<=100)
 
Note: The result of XOR is TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even. I mean, when you check the logical as single then the result will be TRUE, or result will be FALSE.
 
For more understanding, look at the screenshot please: