Forum Discussion
jacob_n
Oct 14, 2021Copper Contributor
SharePoint calculated column formula help
I have a calculated column formula performing a basic subtraction operation between two other columns; call it "cost" column and "account balance" column. The product of the calculated column is dis...
- Oct 15, 2021
Try the following:
=IF([Account balance]-[Cost]<0,0,[Account balance]-[Cost])
If this resolves your issue, please mark it as the answer. Thank you!
Don Kirkham
Oct 15, 2021MVP
Try the following:
=IF([Account balance]-[Cost]<0,0,[Account balance]-[Cost])
If this resolves your issue, please mark it as the answer. Thank you!
jacob_n
Oct 15, 2021Copper Contributor
Don Kirkham Thanks for the reply. That worked well.