Minimum / Maximum Value

How do I go about setting a minimum value and a maximum value for a cell? Example C17*3. I can easily do that but I want the minimum to come out to 12 and the maximum not to exceed 52. So if I have 20 in C17 and the total is 60 I want it to display 52. If I have I hope all of this is making sense. Let me know what your thoughts are on this.

You can use this formula:

=MAX(12,MIN(52,C17*3))

Hope this helps.

Pete