Excel FILTERXML Function
The FILTERXML Function returns specific values from XML text by using the given XPath.
The FILTERXML function returns specific values from XML text.
- The FILTERXML function is introduced in Excel 2013. Therefore, it is unavailable in earlier Excel versions. And it is not available in Excel for the web or Excel for Mac, either.
- The FILTERXML function may appear in Excel for Mac's library, but it doesn’t return results on Mac because it relies on Windows operating system functionality.
- The #VALUE! error value occurs if one of the situations occurs:
- the supplied xml argument is not valid;
- the supplied xml argument contains a namespace with a prefix that is not valid.
As the below screenshot shows, cell B4 contains the XML text. To get the specific data from this XML text using the specified XPath, please do as follows.
Please copy the formula below into cell D4, then press the Ctrl + Shift + Enter keys to get the result.
- n the above formula, //food/name is the input xpath argument.
- In Excel for Microsoft 365, you can directly press the Enter key after you input the formula to get the result because Excel 365 supports the dynamic arrays feature that spills the results automatically.
Excel EVEN Function
The EVEN function rounds numbers away from zero to the nearest even integer.
Excel EXP Function
The EXP function returns the result of the constant e raised to the nth power.