Not to Exceed Amount Formula

[Jamm]

I would like to create a formula which adds a range of columns up to a
maximum of a certain amount.

For example, the total sum is not to exceed 500.
If the total in a range of columns adds up to 455, I would like the "totals
column" to show 455. But if the total adds up to 980, I would like it to
show 500.

Is this possible?

Thank you

 

[Peo Sjoblom]

Maybe

=MIN(500,SUM(Range))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Jamm]

Thank you

Maybe

=MIN(500,SUM(Range))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)