Julián Elizondo
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
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)
Ned Krastev
Instructor
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!