The CONCAT function was officially introduced with Excel 2016, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010 & 2013 versions. It works exactly as its original Microsoft counterpart. Description The CONCAT function joins text from multiple ranges and/or strings into a single text string. It is designed as the modern replacement for … Read more
The IFNA function was officially introduced with Excel 2013, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007 & 2010 versions. It works exactly as its original Microsoft counterpart. Description The NUMBERVALUE function converts a text string representing a number into a numeric value, in a locale-independent way. This means you can specify exactly which characters … Read more
The IFNA function was officially introduced with Excel 2013, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007 & 2010 versions. It works exactly as its original Microsoft counterpart. Description The IFNA function allows you to catch and handle only the #N/A error, replacing it with a custom value you specify. If the formula does not return an #N/A error, IFNA simply … Read more
The XOR function was officially introduced with Excel 2013, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007 & 2010 versions. It works exactly as its original Microsoft counterpart. Description The XOR function returns a logical exclusive OR of all arguments. The result of XOR is: This is particularly useful for: Syntax =XOR(logical1,[logical2],…) Argument Description logical1 The first … Read more
If you didn’t do it yet, please download the file. You will received a compressed file (.zip, .rar or .7z), and you have to extract it. You will see two .xll files. They are the same add-in but one is the 32 bit version, the other runs at 64 bits. You can easily tell which … Read more
The ISFORMULA function was officially introduced with Excel 2013, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007 & 2010 versions. It works exactly as its original Microsoft counterpart. Description The ISFORMULA function checks whether a referenced cell contains a formula and returns TRUE if it does, or FALSE if it contains a constant value, text, or is … Read more