Numbers - Setting a maximum value

Discussion in 'Mac Apps and Mac App Store' started by krkh99, Aug 26, 2014.

  1. krkh99 macrumors newbie

    May 15, 2010

    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. :)
  2. neutrino23 macrumors 68000

    Feb 14, 2003
    SF Bay area
    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.

Share This Page