Last answered:

20 Mar 2023

Posted on:

01 Feb 2022


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."


2 answers ( 0 marked as helpful)
Posted on:

02 Feb 2022


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!

Posted on:

20 Mar 2023


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.



Submit an answer