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