what is ifna formula in excel?
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. ... The purpose of the IFNA function is to use an alternate value instead of the #N/A error.