How to allow Numbers to be added but not any text

Hi, i go into data validation and click on the custom setting then i enter this:

=IF(K10="Metric", 14<G12, IF(K10="Imperial", 30<G12))

So only the correct minimum number can be typed in, if K10 is Metric or Imperial. If its anything lower then what it should a stop message appers.

I went to test this and it works perfectly but i then discovered another problem, it allows me to enter text too.

Is there a way to stop text from being entered and only numbers higher then 30 if K10 is imperial or higher then 14 if K10 is metric? Please tell me what to do!

Please help!

Many thanks in advance!

Hi

Data validation whole number should do the trick

Chris

hi NameUse, try:
=AND(IF(K10="Metric",G12>14,IF(K10="Imperial",G12>30)),ISNUMBER(G12))

if your results in K10 can only be either of them, it can be further shorten to:
=AND(IF(K10="Metric",G12>14,G12>30),ISNUMBER(G12))

Hi

Yes when you did your data validation it gives you the opportunity to select cell input change it from default to whole number and that should stop text being entered if you are unsure can you post a sample worksheet and either myself or someone else will have a look and see if we can rectify the situation for you.

Chris