On Mon, 10 Oct 2005 09:31:02 -0700, "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
Because you're using the wrong structure for an If statement. Try
=IF(AND(A13,A1<7),"ok","not ok")
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|