Need to cap a sum

[Terri]

This may be very basic, but I have a column that I need to sum, but if the
total is over 1000, it only shows 1000. Any clues as to how to accomplish
this?

 

[Mike H]

Hi,

Try this

=MIN(1000,SUM(A1:A20))

Mike

 

[Jacob Skaria]

=MIN(value,1000)

If this post helps click Yes

 

[Eduardo]

Hi,
Not sure if I correctly understand you if the sum is the column is more than
1000 you want to show 1000 if yes use

=if(sum(a1:a100)>1000,1000,sum(a1:a100))