Setting a maximum amount in a cell calculation

[terrymck]

Is there a way to set a maximum amount on a cell calculation? If I'm
inflating rents out over 10 years, for example, but want the increases
to stop when they achieve a level (shown in another cell) -- can I do
that?

Terry

 

[Frank Kabel]

Hi
maybe something like
=MIN(your_limit,your_formula)