Custom Validation

K

kalz

my validation criterias for the cell are:
input must be divisble to 4 and larger than 100

I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one
cell.
Would anyone know the way to fulfill both?
thx!
 
P

Peo Sjoblom

=AND(MOD(A1,4)=0,A1>100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

custom data validation on cells with data validation values 2
VLOOKUP & Data Validation 0
A data validation question 1
Multiple data validation criteria? 2
Validation List 2
2 Data Validations Q 7
SUMIF using value from MOD function 2
Need help with Data Validation Formula for a set of numerical andtext-based values 7

Top