Limit Cell Content
 

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

Limit Cell Content
 

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



--
Regards
Dave Hawley
www.ozgrid.com
"Bob Zimmerman" wrote in message
...
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

Limit Cell Content
 

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 tabData toolsData 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 DataValidation
Allow: Custom
Formula:

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

OK out


--
Biff
Microsoft Excel MVP


"Bob Zimmerman" wrote in message
...
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

Limit Cell Content
 

Thank you. I'm using Excel 2003.

Your formula works great.

Thanks again.

Bob Z

"T. Valko" wrote:

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 tabData toolsData 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 DataValidation
Allow: Custom
Formula:

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

OK out


--
Biff
Microsoft Excel MVP


"Bob Zimmerman" wrote in message
...
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


.

Limit Cell Content
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bob Zimmerman" wrote in message
...
Thank you. I'm using Excel 2003.

Your formula works great.

Thanks again.

Bob Z

"T. Valko" wrote:

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 tabData toolsData 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 DataValidation
Allow: Custom
Formula:

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

OK out


--
Biff
Microsoft Excel MVP


"Bob Zimmerman" wrote in message
...
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


.