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.
Remarks:
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.
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:
0 Comments
|
Archives |