Need to cap a sum

  • Thread starter Thread starter Terri
  • Start date Start date
T

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?
 
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))
 
Back
Top