« Back

How to deal with excel formula code errors

May 11, 2020 8:01 pm

Category:

Excel is an incredibly powerful application that allows for data of different sizes to be stored in a spreadsheet that can then be analysed and reported. One of the most useful functions available in the application is that of formulas. You can take away the need for any manual calculations by using the formula function. This is particularly useful if you have imported data from a PDF to Excel converter like the one from PDF TABLES. There are occasions however, when errors in your formula coding can occur. Here we look at some of the most common ones to occur and their possible reasons. .

Image Credit

 

#DIV/0!

This error code means that your formula is trying to divide something by 0. This usually occurs if you have data that contains a 0 or an incomplete set of data. As you fill in your data fields you may find that the error code rectifies itself.

Image Credit

 

#N/A

This not applicable error can be infruitating and there are number of reasons that it can occur but the most common is as a result of a spelling mistake being made in the coding or a key component such as comma or colon having been left out, or a space in the wrong place.

« Back