The MINIFS function was officially introduced with Excel 2019, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013 and 2016 versions. It works exactly as its original Microsoft counterpart. Description The MINIFS function returns the largest numeric value in a range of cells that meet one or more specified conditions. It is the conditional … Read more
The MAXIFS function was officially introduced with Excel 2019, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013 and 2016 versions. It works exactly as its original Microsoft counterpart. Description The MAXIFS function returns the largest numeric value in a range of cells that meet one or more specified conditions. It is the conditional … Read more
The IFS function was officially introduced with Excel 2019, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013 and 2016 versions. It works exactly as its original Microsoft counterpart. Description The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. It is designed … Read more
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