Forum Discussion

jacob_n's avatar
jacob_n
Copper Contributor
Oct 14, 2021
Solved

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...
  • Don Kirkham's avatar
    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!

Resources