Make the sum of cells no greater than X

Joined
Nov 17, 2015
Messages
1
Reaction score
0
Hi.
I want to add a number of cells but do not want the value to be greater than 25.
There are 9 cells and the equation is =SUM(B57:J57) but the maximum value I want is 25.
Is there a formula I can use to limit this?

Thank you.
 
Back
Top