Numbers - Setting a maximum value

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

  1. krkh99 macrumors newbie

    Joined:
    May 15, 2010
    #1
    [​IMG]

    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

    Joined:
    Feb 14, 2003
    Location:
    SF Bay area
    #2
    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