between - function?
 

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

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

Regards,

Peo Sjoblom

"lucas" wrote in message
...
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

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
__________________________

=IF(AND(A14,A1<10),"ok","not ok")

"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

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

Cool! Thanks very much!

"Alvin" wrote:

=IF(AND(A14,A1<10),"ok","not ok")

"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

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