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

Question

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.

Answer 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!

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

Submit an answer

related questions