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
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!
Submit an answer
Solutions for practice exam : 3 are very confusing need video for explanation please