Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >
DRae1005Copper ContributorMay 14, 2024Insurance spreadsheet Hi I am trying to get the spreadsheet to give a sum of zero in the cell if the formula sums to a negative number or keep the positive number if it is greater than 0. I am solving for how much the i...Show More
dscheikeyBronze ContributorMay 31, 2024DRae1005 With MAX() you can prevent negative results from being displayed or that the result is zero.For example: =MAX(0,J9-J22-J24)See also the enclosed example.DRae1005.xlsx11 KB
