Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 __________________________ |
#4
|
|||
|
|||
=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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |