Question regarding Q30 in the exam
Is it allowed to use IFNA when the error results in #DIV/0!? If yes, can you provide an example I'm having trouble coming up with and answer. I already know ISERROR and IFERROR but can't seem to find the answer to IFNA.
I found this phrase while searching how to do it using IFNA function: "As the IFNA function is more specific and targets only a specific error, which is #N/A, it is more appropriate to use than IFERROR function in certain circumstances. All other errors, such as #DIV/0! or #REF!, are ignored by the IFNA function. IFERROR, on the other hand, would trap other errors too."
Good to hear from you. Thanks for reaching out.
Well, as you have suggested - IFNA won't catch a DIV/O error, so it is better to use IFERROR, correct?
I'm not sure I completely understand your question. Could you elaborate a bit, please? Thanks!