Example nesting IFERROR and IFNA:
=IFERROR(IFNA(4/0,"Value Not Found"),"At least it's not an N/A error!")
Need your spreadsheet to look professional and communicate better with your customers? Utilize this function to prevent those scary "#N/A" error messages from making your users shout "IT'S BROKEN" when it isn't.
Please subscribe if you enjoyed the video or if the video taught you how to use the IFNA function in Microsoft Excel.
More information:
IFNA function: https://support.office.com/en-us/arti...
IFERROR function: https://support.office.com/en-nz/arti...
Connect with me on Facebook: / dave.excel.5
Follow me on Twitter: / excelwithdave
Please drop my channel: / @exceltutorialswithdave3960
Share this video with friends: • How to Use Excel's IFNA Funciton 2013...
Watch video How to Use Excel's IFNA Funciton 2013 And Newer: Quick Tutorial online without registration, duration hours minute second in high quality. This video was added by user Dave Z 07 December 2014, don't forget to share it with your friends and acquaintances, it has been viewed on our site 468 once and liked it 3 people.