Two conditions for a cell

[mallquimarco]

Hi everyone, first post. I something simple I suppose.
I need to set up a two conditions in a cel.
The user is allowed just to write a number >= 10 and multiples of 5.
So far I have just ine part of the statement which is the easier (>=10) but I don´t know how the set up the "multiples" part.
Please help. Thanks in advance.

 

[etaf]

try
=AND(MOD(A4,5)=0,A4>=10)

Book1
	A	B	C	D	E
3
4	35		TRUE	TRUE
5
Sheet1

Cell Formulas
Range	Formula
C4	C4	=MOD(A4,5)=0
D4	D4	=AND(MOD(A4,5)=0,A4>=10)

Cells with Data Validation
Cell	Allow	Criteria
A4	Custom	=AND(MOD(A4,5)=0,A4>=10)

 

[mallquimarco]

Hi ETAF, sadly it doesn´t work. What I need is that the user just can input 10, 15,20,25,30,35,40,45, etc. Not less than 10, no 11,no 12,no 13,no 14,no 16, no 17, etc. I set up this:

=SI(Y(RESIDUO(K18,5)=0),K18>=10,1,0)

but I didn´t work either.

 

[etaf]

Worked for me
Data validation - custom ,
input the formula

=AND(MOD(A4,5)=0,A4>=10)

=AND(MOD(K18,5)=0,K18>=10)

user can only put in those multiples of 5 but must be 10 or more

Not sure of language you are set to
So dont know the formula you are using


I also added the MOD formula in C4 and MOD & AND in E4

Link to working file

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[sandy666]

did you try this in Data Validation

 

[sandy666]

maybe: =Y(RESIDUO(K18,5)=0,K18>=10)
select K18 and use Data Validation as above

 

[mallquimarco]

I have this statement

but it doesn´t allow me to input anything

 

[sandy666]

did you try formula without SI as in post#6 ?

 

[mallquimarco]

did you try formula without SI as in post#6 ?

When I use "=" at the beginning of the statement I get this:

If I not use "=" I can save the statemente but it doesn´t work in the sheet

This is driving me crazyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

 

[sandy666]

your separator is , (comma) or ; (semicolon) ?

=Y(RESIDUO(K18,5)=0,K18>=10)
or
=Y(RESIDUO(A4;5)=0;A4>=10)
I suggest the second