Set a minimum value on a cell

**PY_** · 07-21-2010, 05:55 PM

Is there a way to set a minimum value on a cell?

A1 + B1 = C1

I want the minimum value to be 10. After it reaches 10, it would just add up the numbers like normal.

Examples:
2 + 2 = 10
5 + 4 = 10
4 + 6 = 10
5 + 6 = 11
6 + 6 = 12

Something like that.

**luvthavodka** · 07-21-2010, 05:56 PM

=if(a14+b14<10,10,a14+b14)

**shg** · 07-21-2010, 07:40 PM

Or =MAX(A1+B1, 10)

**PY_** · 07-27-2010, 05:34 PM

Thanks to both of you!

**vtegroup** · 05-18-2017, 04:16 PM

Looking for something similar, struggling to get it working

Refractory.JPG

Cell B5 input of the diameter in centimeter
Cell B12 needs to have two minimum values

Optimum is 10% of Cell B5, with a minimum of 10 cm.

Cell B8 is filled with the thickness required by the user, let's say they fill 8 cm
B12 needs to show the optimum solution.

Thanks guys

**Heitor2018** · 06-12-2018, 08:00 AM

Originally Posted by shg

Or =MAX(A1+B1, 10)

Still not working. is there any other way

**FDibbins** · 06-12-2018, 02:27 PM

Heitor2018 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.