Numbers - Setting a maximum value

[krkh99]

Hi guys, does anyone here know how to set a maximum value?

In the photo above, I would like to bring down the value automatically to 200.

Meaning, every time the amount is more than 200, it will not go above 200.

Thanks guys.

 

[neutrino23]

Is it the cell with 342 that should be no more than 200? Is this a calculated value?

For example if you are taking 341.9 as input you could do something like this.


= min(200, B3)

Assuming B3 was your input value and cell B4 is your output.