between function?
in [Functions]
|
From: klh84 on 25 Feb 2010 13:35 I am trying to write an if function to find out if a value falls between two numbers =if(AM7(is between 0.005 and 0.999),"etc","etc") Is there a function I can use to make this happen?
From: Eduardo on 25 Feb 2010 13:41 Hi, you can use =if(and(AM7>+0.005,AM7<=0.999),etc,etc) "klh84" wrote: > I am trying to write an if function to find out if a value falls between two > numbers > > =if(AM7(is between 0.005 and 0.999),"etc","etc") > > Is there a function I can use to make this happen?
From: Joe User on 25 Feb 2010 13:47 "klh84" wrote: > =if(AM7(is between 0.005 and 0.999),"etc","etc") Ostensibly, you might want: =if(and(0.005<=AM7,AM7<=0.999),"etc1","etc2") But beware of such comparisons. Most decimal fractions, and those in particular, cannot be represented exactly. Moreover, if AM7 is formatted as Number with 3 decimal places, a number like 0.9991 might __appear__ to be 0.999, but it will fail the "between" test. It would be better to write: =if(and(0.005<=round(AM7,3),round(AM7,3)<=0.999), "etc1","etc2") Even better: if AM73 can be =round(formula,3), then the first comparison will work as intended. ----- original message ----- "klh84" wrote: > I am trying to write an if function to find out if a value falls between two > numbers > > =if(AM7(is between 0.005 and 0.999),"etc","etc") > > Is there a function I can use to make this happen?
From: T. Valko on 25 Feb 2010 13:51 Use the AND function: =IF(AND(AM7>=0.005,AM7<=0.999),"etc","etc") -- Biff Microsoft Excel MVP "klh84" <klh84(a)discussions.microsoft.com> wrote in message news:2B902C24-5839-4B2D-BE4C-0D670CD0D5B0(a)microsoft.com... >I am trying to write an if function to find out if a value falls between >two > numbers > > =if(AM7(is between 0.005 and 0.999),"etc","etc") > > Is there a function I can use to make this happen?
|
Pages: 1 Prev: How do I make cells not move in a worksheet Next: counting the number an item appears |