excel IFNA - Free Excel Tutorial

Excel XLOOKUP Function

Excel XLOOKUP Function was added into Excel as a beta feature in August 2019 and is now accessible exclusively in Microsoft 365. (as of July 2021). However, if you fall into this category and often deal with big sets of data in Excel, understanding this method is worthwhile. In this lesson, we will demonstrate how… read more »

Excel IFNA Function

This post will guide you how to use Excel IFNA function with syntax and examples in Microsoft excel. Description The Excel IFNA function returns an alternate value you specify if a formula results in an #N/A error, or returns the result of the formula. The IFNA function is a build-in function in Microsoft Excel and it… read more »