We use google sheets to do price updates for our websites. Sometimes there may be a typo that allows too low of a value and we want to avoid the possibilty of these kinds of errors. Ideally, looking for a way to set a minimum value allowed for an individual cell in google sheets.


Price = $22.50

We want to avoid mistakes like:

Price = $2.25

Is there a way to set a minimum price on this cell so that the value cannot be entered unless it is higher than say, $20 for this example. Thanks for your help!


1 Answer 1


Use Data > Data validation > Is greater than or equal to > 20.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.