Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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
"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
"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
Minimum value for a cell
