Limit Cell Content

  • Thread starter Thread starter Bob Zimmerman
  • Start date Start date
B

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
 
My limits are any value >=15.0 to <=100.0
as long the is only 1 decimal point.
Click to expand...

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
 
Back
Top