Are you using this function for a custom data validation? If so, instead of
choosing Custom, choose "Decimal" or "Whole Number" from the "Allow" box and
enter your min and max values that way.

Otherwise if this formula is just looking to outout "ok" or "not ok" in a
cell, update your formula to this:

=IF(AND(A13,A1<7),"ok","not ok")

--
Regards,
Dave


"lucas" wrote:

Hi,

I was wondering whether is there an option (Excel 2002) to make between
function. I mean that cell A1 is my variable. Now, by using IF I would like
to say that if A1 is more than 3 and less than 7 then "ok" - other values
should give "not ok". So I wrote =if(3<A1<7;"ok";"not ok") and it doesn't
work :-( Why?

Thanks, lucas