Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: Table Of Contents 00:00 Introduction 00:06 Fix #### Error 01:03 Fix #NAME? Error 01:32 Fix #DIV/0 Error 03:08 Fix #NULL Error 03:44 Fix #REF Error 04:47 Fix #VALUE! Error 05:55 Resolve Error With IFERROR 08:00 Conclusion Error #### This error occurs on the screen when the data so inserted in the cell, does not fit in. Error #NAME? This type of error pops on the screen when we have written the wrong function. Here by wrong function we mean the wrong spellings. Error #DIV/0! This is the type of error that occurs on the screen when you divide something by zero. As we are aware of the fact that something divided by zero is considered as an indeterminate form. Error #NULL! As you can observe in the image above, the following calculations were going on perfectly fine but just because of a missing sign it ended up into #NULL! Error. Error #REF! This error pops on the screen when one of the cells that we have referred to, in the formula is not valid. Error #VALUE! As you can observe in the image above, one of the values is not valid as per the calculation being used.