Sharepoint Calculated Columns

[DBreezy92]

Hi, hopefully this is the correct forum to help.

I have a sharepoint site which has 5 columns of data which captures different financial amounts, I am looking to created a calculated column on sharepoint which adds and subtracts the 5 columns in a specific order to try and make sure the output is a zero.

I have created the formula in Excel already but can’t seem to sus it in Sharepoint. The formula on excel looks like;

=column1-sum(column2+column3-column4-column5)

Can anyone help with this?

[#2]

@DBreezy92 To add numbers in two or more columns in a row, use the addition operator (+) or the SUM function.

Examples: 

=[Column1]+[Column2]+[Column3]

OR

=SUM([Column1],[Column2],[Column3])

To subtract numbers in two or more columns in a row, use the subtraction operator (-) or the SUM function with negative numbers.

=[Column1]-[Column2]

OR

=SUM([Column1], [Column2], [Column3])

For more information, check this documentation:  Calculated Field Formulas - Mathematical formulas 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.