Last answered:

14 Apr 2023

Posted on:

13 Apr 2023


Resolved: Introduction to Excel - Final Exam Question - Formula for Hiding Errors


Question no. 30 gives us 3 answers to choose from, IFERROR, ISERROR, and IFNA. I chose IFERROR and got marked as wrong because apparently all three work, but that is not true. File 'Multiple options', Sheet '6.', cell M14 shows the error '#DIV/0!'. Formula IFNA won't work because it is not an NA error. 

1 answers ( 1 marked as helpful)
Posted on:

14 Apr 2023


Thanks so much for pointing this out! I've revised the question. It will be updated with the next course update. You are absolutely correct. Appreciate it!

Submit an answer