SUM - set maximum value

[Graham370]

I have created a formula and if the value of the calculation exceeds say 1,000 I want the value to default to 1,000.  Please advise how I can achieve this.

[#2 · Accepted solution]

@Graham370 

It could be

=MIN(1000, SUM(...) )

[#3]

Excellent Sergei, that works. Many thanks!

[#4]

@Graham370 , you are welcome

[#5]

Every time I try to do an auto SUM or manual SUM the result is always ########. How can I fix this?

[#6]

@sabaine Please make this column wider, that's most probable reason