Excel

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

The FORMULATEXT 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 FORMULATEXT function returns a formula as a text string from a referenced cell. This is extremely useful for: Syntax =FORMULATEXT(reference) Argument Description reference … Read more

AGGREGATE function was officially introduced with Office 2010, but thanks to MFU you can now run it on your 2007 version. It works exactly as its original MS counterpart. Description The AGGREGATE function returns the aggregate calculation (such as SUM, AVERAGE, MAX, MIN, etc.) from a list or database, with the option to ignore hidden rows and … Read more