ExcelBanter - Need to cap a sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need to cap a sum (https://www.excelbanter.com/excel-discussion-misc-queries/244968-need-cap-sum.html)

Terri

Need to cap a sum

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

Need to cap a sum

Hi,

Try this

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

Mike

"Terri" wrote:

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?

Jacob Skaria

Need to cap a sum

=MIN(value,1000)

If this post helps click Yes
---------------
Jacob Skaria

"Terri" wrote:

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?

Eduardo

Need to cap a sum

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))

"Terri" wrote:

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?

All times are GMT +1. The time now is 03:14 AM.