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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top