Discussion Re: SharePoint calculated column formula help in SharePoint
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2849657#M54321
<P>Try the following:<BR />=IF([Account balance]-[Cost]<0,0,[Account balance]-[Cost])<BR /><BR />If this resolves your issue, please mark it as the answer. Thank you!</P>Fri, 15 Oct 2021 12:26:19 GMTDon Kirkham2021-10-15T12:26:19ZSharePoint calculated column formula help
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2847635#M54303
<P>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 displayed in a "remaining cost" column. The intention is to trigger a flow if the cost exceeds the account balance, showing a positive value in the remaining balance column. </P><P>For example:</P><P> </P><P>Cost = $12. Account balance =$10. Remaining cost (calculated column) = $2</P><P> </P><P>The formula looking like, =[Account balance]-[Cost]</P><P> </P><P>However, if the account balance is greater than the cost, the Remaining cost is displayed as a negative number. </P><P> </P><P>Cost = $10. Account balance = $12. Remaining cost = ($2)</P><P> </P><P>Is there a way to perform the calculation, but limit the minimum value to be zero? </P><P> </P>Thu, 14 Oct 2021 19:30:55 GMThttps://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2847635#M54303jacob_n2021-10-14T19:30:55ZRe: SharePoint calculated column formula help
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2849657#M54321
<P>Try the following:<BR />=IF([Account balance]-[Cost]<0,0,[Account balance]-[Cost])<BR /><BR />If this resolves your issue, please mark it as the answer. Thank you!</P>Fri, 15 Oct 2021 12:26:19 GMThttps://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2849657#M54321Don Kirkham2021-10-15T12:26:19ZRe: SharePoint calculated column formula help
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2851491#M54331
<P><LI-USER uid="139606"></LI-USER> Thanks for the reply. That worked well.</P>Fri, 15 Oct 2021 20:46:46 GMThttps://techcommunity.microsoft.com/t5/sharepoint/sharepoint-calculated-column-formula-help/m-p/2851491#M54331jacob_n2021-10-15T20:46:46Z