Hi Kristy,

Am Wed, 11 Feb 2015 06:28:32 +0000 schrieb KristyAlison:

I am trying to create a cell (T5) that refers to another cell (S5) that
contains a value / number, but I don't want the T5 value to exceed 60,
at the same time not fall below 0.

I know the functions of =MIN(60, and =MAX(0, . But is it possible to
have both work together to achieve what I want?

your problem is not really clear. Can you post some examples of numbers
in S5 and the expected output in T5?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional