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

Follow this topic

Christian Valiente

Last answered:

20 Mar 2023

Posted on:

01 Feb 2022

Question regarding Q30 in the exam

in Introduction to Excel / Bridge Chart

2 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

02 Feb 2022

Małgorzata Biskup

Posted on:

20 Mar 2023

Question regarding Q30 in the exam

Submit an answer

related questions