Limit Cell Content

[Bob Zimmerman]

I would like to know how to limit a cell to only allow entry of the following
number values of 1 decimal point.
My limits are any value >=15.0 to <=100.0 as long the is only 1 decimal point.

I'd appreciate any input.

Bob Z

 

[ozgrid.com]

Data Validation
http://www.ozgrid.com/Excel/data-validation.htm

 

[T. Valko]

My limits are any value >=15.0 to <=100.0

as long the is only 1 decimal point.

What version of Excel are you using?

Let's assume cell A1 is the cell of interest.

In Excel 2007...

Select cell A1
Data tab>Data tools>Data Validation
Allow: Custom
Formula:

=AND(A1>=15,A1<=100,MOD(10*A1,1)=0)

OK out

In Excel 2003 and earlier...

Select cell A1
Goto the menu Data>Validation
Allow: Custom
Formula:

=AND(A1>=15,A1<=100,MOD(10*A1,1)=0)

OK out

 

[Bob Zimmerman]

Thank you. I'm using Excel 2003.

Your formula works great.

Thanks again.

Bob Z

 

[T. Valko]

You're welcome. Thanks for the feedback!