Guys,

Thx for all replies. Formula works.

BTW, there are 2 amazing things:
1) how helpful & willing to be helpful other (vel you) are,
2) how smart Excel is (is there anything one cannot do there?) :-)

Again thanks, lucas

"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