Question: how does ifna work in excel?
Answer: The IFNA function in Excel returns an alternate value as specified by the user if a formula results in an #N/A error. It is a Logical function. This cheat sheet covers 100s of functions that are critical to know as an Excel analyst that was introduced in MS Excel 2013.