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