Google Sheets Data Validation that only allows null string or 1 ~ 100

Tadashi Shigeoka ·  Mon, April 10, 2017

I defined a custom function for Data Validation in Google Sheets that only allows values between 1 and 100, or null strings, so I’ll introduce it.

I defined the validation by combining functions like OR, AND, ISNUMBER, GTE, LTE.

=OR( A2="null", AND(ISNUMBER(A2), GTE(A2, 10), LTE(A2, 100)) )

Data validation is highly flexible and can do various things, which is convenient.

Reference Information

That’s all from the Gemba.