SharePoint List Calculated Column Division #DIV/0!

In this SharePoint tutorial, I will explain how to fix error as “SharePoint List Calculated Column Division #DIV/0!“.

Error: SharePoint List Calculated Column Division #DIV/0!

I have a SharePoint List as Sales Product. This SharePoint List has many numbers of columns with different data types. In between that, there is a calculated column (Projected MTD Sales vs Budget Value) that is based upon two other columns. Those two columns are:

  • Projected MTD Sales (Number Data type) and
  • Budget Value (Number Data type)

As per my requirement, I want to calculate the percentage over two columns. For that, I have to divide the column as:

[Projected MTD Sales]/[Budget Value]

When both of the columns (Projected MTD Sales & Budget Value) contain Zero value, then at that time, the result was appearing as “#DIV/0!”.

Since both of the columns are number data types, So I have tried again and again and the result was out the same as the previous.

SharePoint List Calculated Column Division #DIV/0!

When both of the columns should contain zero value, then you can see the resulting error value will appear as like below screenshot.

When both of the columns should contain some number value, then it will calculate and show the exact value where you can see in the 4th option of the below screenshot.

SharePoint list calculated column division

Whereas, I have used this below formula in the SharePoint list Calculated column while the error was appearing.

SharePoint list calculated column

After that, I searched and got one formula which worked for me fine. You can put the below formula to get an appropriate value as:

=IF([BudgetValue]=0,"0",[ProjectedMTDSalesvsBudgetValue($)]/[BudgetValue])

You can follow the below screen to get the exact calculated value.

SharePoint list calculated column division

Once you refresh the SharePoint List, then the calculated value will appear as the below screenshot.

SharePoint list calculated division

You may like following SharePoint tutorials:

In this SharePoint tutorial, We learned how to fix error an error as “SharePoint List Calculated Column Division #DIV/0!“.

>