Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Minimum value for a cell

I need to set a minimum value for a cell. I have a formula, 6000+(Product A6-12000x0.4) The problem is the lowest this value can be is 6000. If the value in cell A6 is 12000 or greater it works fine but if it's lower that 12000 I run into trouble for example if A6=10000 the result is 5400. Is there a way to set the cell to the result of the formula or 6000, whichever is greater?

MacBook Pro TouchBar and Touch ID

Posted on

Reply
Question marked as Solved
Answer:
Answer:

"Is there a way to set the cell to the result of the formula or 6000, whichever is greater?"


The solution is essentially stated in your question.


=MAX(6000,formula)


Plug your formula into the space occupied by "formula"


Regards,

Barry

Posted on

Page content loaded

Question marked as Solved

Mar 14, 2018 8:19 PM in response to ChrisCochrane In response to ChrisCochrane

"Is there a way to set the cell to the result of the formula or 6000, whichever is greater?"


The solution is essentially stated in your question.


=MAX(6000,formula)


Plug your formula into the space occupied by "formula"


Regards,

Barry

Mar 14, 2018 8:19 PM

Reply Helpful (1)
User profile for user: ChrisCochrane

Question: Minimum value for a cell