Sum column with a cap?

I am working on expense reports and was curious if i could put a cap on a sum column? like if i were to add $300 and $300 totaling $600 but the sum never went higher than $500

Attachment 781858 This is what the report looks like if that help

How about

Formula:

Please Login or Register  to view this content.

Sorry i need it specifically for column D, i should have specified that.

What range in col D?

=SUM(D3:D20) is what i have currently

In that case try

Formula:

Please Login or Register  to view this content.

That is exactly what i needed, thank you!

You're welcome & thanks for the feedback.