validating data input

  • Thread starter Thread starter DuQuesne
  • Start date Start date
D

DuQuesne

How can I restrict data entered in excel to multiples of a number?
For example, I want a spreadsheet that will list denominations and I want to
restrict each column to only accept multiples of $10, $20, $50, $100 etc.
 
DuQuesne said:
How can I restrict data entered in excel to multiples of a number?
For example, I want a spreadsheet that will list denominations and I
want to restrict each column to only accept multiples of $10, $20,
$50, $100 etc.
Click to expand...

Hi

1. Highlight the cell range
2. Go to 'Data - Validation'
3. As validation rule enter the following formula
=MOD(A1,10)=0

- A1 is the upper left cell of your highlighted range
- This formula restricts your entries to 10 or multiples of 10

Frank
 
Just an additional note. If the active (white) cell of your selection is
other than A1, than change the formula accordingly.
 
thanx :)

Frank Kabel said:
Hi

1. Highlight the cell range
2. Go to 'Data - Validation'
3. As validation rule enter the following formula
=MOD(A1,10)=0

- A1 is the upper left cell of your highlighted range
- This formula restricts your entries to 10 or multiples of 10

Frank
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading data validation? 4
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Custom Reporting Across Sheets 1
Offset and Small functions with blank rows? 0
Calculation Time 2
Dynamic Validation List 1
Validation... 3
Data Validation using Unique Values 2

Back
Top