Question regarding Q30 in the exam
Hi,
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."
Best,
Christian
Hi Christian,
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!
Hi Ned,
The point is that you have a wrong answer for Q30 which includes IFNA as a solution whereas it does not work for DIV/O error.
Regards
Margaret