Last answered:

14 Apr 2023

Posted on:

13 Apr 2023

0

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

Hi.


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)
Instructor
Posted on:

14 Apr 2023

1

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