Not to Exceed Amount Formula

  • Thread starter Thread starter Jamm
  • Start date Start date
J

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
 
Maybe

=MIN(500,SUM(Range))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Thank you
Peo Sjoblom said:
Maybe

=MIN(500,SUM(Range))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Back
Top