|Subject:||Re: Check if a number is within a certain range|
|Date:||Thu, 17 Jul 2008|
On 17 Jul, 15:20, "Don Guillett" <dguille.…@austin.rr.com> wrote:
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille.…@austin.rr.com<ain.…@gmail.com> wrote in message
> > Hi
> > I'm trying tocheckif a number is within a certainrange.
> > EG:
> > say i get a result of 9% in a cell, and in the next cell i want to
> >checkif that falls between therangeof 0.1% and 10% and if it does
> > then apply a formula how do i do this?
> > Anyone know please?
Thanks for that, but i've tried that but it keeps throwing back 2
which isn't what i'm looking for :(
Re: Check if a number is within a certain range posted by Don Guillett on Thu, 17 Jul 2008