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 Mar 14, 2018 7:50 PM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Minimum value for a cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.